What about dynamic queries?
From: [email protected] [mailto:[email protected]] On Behalf Of Dmitriy Igrishin Sent: Saturday, October 02, 2010 6:40 AM To: Ozer, Pam Cc: [email protected] Subject: Re: [SQL] Random sort with distinct Hey Ozer, How about dynamic queries? 2010/10/2 Ozer, Pam <[email protected]> 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.
