Viewing 2 posts - 1 through 2 (of 2 total)
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,
February 2, 2006 at 6:57 am
#618374
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...
February 2, 2006 at 2:08 am
#618310