MySQL Forums
Forum List  »  Newbie

ORDER BY question
Posted by: j t
Date: February 04, 2009 06:06PM

Hello, I have a simple sql statement that reads 'SELECT DISTINCT make AS TNPC
FROM used_vehicle GROUP BY make ORDER BY make ASC'

I would like to ORDER BY very specifically with based on records in the 'make' field. For example I would like to ORDER BY Dodge,Honda,Toyota first and then the rest of the result could be ASC.

Is this possible? If so any help would be greatly appreciated.

Options: ReplyQuote


Subject
Written By
Posted
ORDER BY question
j t
February 04, 2009 06:06PM
February 04, 2009 10:04PM
j t
February 05, 2009 11:50AM
j t
February 05, 2009 11:54AM
February 05, 2009 12:42PM
j t
February 05, 2009 02:53PM
February 05, 2009 07:42PM
j t
February 12, 2009 05:09PM
February 12, 2009 05:19PM
j t
February 12, 2009 06:55PM
j t
February 12, 2009 08:53PM
February 12, 2009 09:13PM
j t
February 12, 2009 10:14PM
February 13, 2009 09:31AM
j t
February 13, 2009 12:42PM
February 13, 2009 02:19PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.