Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: COUNT(DISTINCT xxx)

    Ok Neil Coe !!

    thank you very much!!!!

    SELECT COUNT(marq) FROM car WHERE car.id_car IN (SELECT MAX(id_car) FROM car GROUP BY marq)

    the result is 3

    So my problem is solved.

    See you soon,

     

     

  • RE: COUNT(DISTINCT xxx)

    First thanks to answer me.

    Then vehicule is a mistake, the right table's name is "car" and i really try the queries with car.

    I try:

    SELECT marq, COUNT(marq) AS Marqs FROM car GROUP...

Viewing 2 posts - 1 through 2 (of 2 total)