sql query

[stevelibby]

hi peoples
my brain is not working today...
i have to doa query and i cant work it out, so here it is..
i have a table of cars with make,models,doors and so on.
i am trying to filter out the first car of each make and i cant seem to do it..
any ideas?

[FalseDawn]

SELECT FIRST(car) FROM cars GROUP BY make

If by "first" you mean "first alphabetically", then try MIN() instead of FIRST()