Re: ORDER BY question
Posted by:
j t
Date: February 05, 2009 02:53PM
Hmmm. I put this "SELECT make AS TNPC
FROM used_vehicle GROUP BY make ORDER BY FIELD(make, 'Dodge','Toyota','Honda'),
make" if I am understanding you correctly and it places Dodge, Toyota and Honda at the bottom of the list, not first. Strange!
I did not have any issues with your second option so I am using that. Thanks again.
Subject
Written By
Posted
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
Re: ORDER BY question
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.