Random sort with distinct
От | Ozer, Pam |
---|---|
Тема | Random sort with distinct |
Дата | |
Msg-id | 216FFB77CBFAEE4B8EE4DF0A939FF1D10182C8@mail-001.corp.automotive.com обсуждение исходный текст |
Ответы |
Re: Random sort with distinct
Re: Random sort with distinct Re: Random sort with distinct |
Список | pgsql-sql |
<div class="WordSection1"><p class="MsoNormal">I have the following query<p class="MsoNormal"> <p class="MsoNormal">SelectDistinct VehicleMake, VehicleModel<p class="MsoNormal">From VehicleYearMakeModelTrim<p class="MsoNormal">Orderby random()<p class="MsoNormal">Limit 10;<p class="MsoNormal"> <p class="MsoNormal">I don’t want tobring back the random number I just want the sort order to be random. How can I sort randomly? This query breaks becauserandom() is not in the select.<p class="MsoNormal"> <p class="MsoNormal">Thanks<p class="MsoNormal"> <p class="MsoNormal">Pam<pclass="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><br /><br /></span></div>
В списке pgsql-sql по дате отправления: