SQL statement ... count()

[ighidan]

hello guys,
i have a db table called "vehicle", the table contains a field called "model". i wanna retrieve the count() for each model by one query. i want my query to output: count(Q45), count(X40), count(BMW2000), etc ....
How can i do this?

Thanks. <CFQuote>THE JOURNEY OF A 1000 MILES BEGINS WITH 1 STEP</CFQuote>

 

[ighidan]

Thank you guys, I found the solution:

<cfquery datasource=&quot;#application.dsn#&quot; name=&quot;q&quot;>
Select model, count(model) as Total
From vehicle
Group By model
</cfquery> <CFQuote>THE JOURNEY OF A 1000 MILES BEGINS WITH 1 STEP</CFQuote>