Re: [SQL] Random sort with distinct

[Dmitriy Igrishin]

Hey Ozer,

How about dynamic queries?

2010/10/2 Ozer, Pam <po...@automotive.com>

>  I have the following query
>
>
>
> Select Distinct VehicleMake, VehicleModel
>
> From VehicleYearMakeModelTrim
>
> Order by random()
>
> Limit 10;
>
>
>
> 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.
>
>
>
> Thanks
>
>
>
> Pam
>
>
>
>


-- 
// Dmitriy.