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.
Subject
Written By
Posted
ORDER BY question
February 04, 2009 06:06PM
February 04, 2009 10:04PM
February 05, 2009 11:50AM
February 05, 2009 11:54AM
February 05, 2009 12:42PM
February 05, 2009 02:53PM
February 05, 2009 07:42PM
February 12, 2009 05:09PM
February 12, 2009 05:19PM
February 12, 2009 06:55PM
February 12, 2009 08:53PM
February 12, 2009 09:13PM
February 12, 2009 10:14PM
February 13, 2009 09:31AM
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.