[SQL] Random sort with distinct

[Ozer, Pam]

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