Re: Random sort with distinct
2010-10-02 13:42:29 GMT
On 10/01/2010 04:51 PM, Ozer, Pam wrote:
I have the following query
Select Distinct VehicleMake, VehicleModel
Order by random()
I don’t want to bring back the random number I just want the sort order to be random. How can I sort randomly? This query breaks because random() is not in the select.
-- Lee Hachadoorian PhD Student, Geography Program in Earth & Environmental Sciences CUNY Graduate Center