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