distinct
От
Otwell, Andrew (ISSAtlanta)
Тема
distinct
Дата
Msg-id
DF3CC311E898D311A3670008C709BD2302A110C6@msgatl01.iss.net
Список
Дерево обсуждения
distinct "Otwell, Andrew (ISSAtlanta)" <AOtwell@iss.net>
Re: distinct Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: distinct Tom Lane <tgl@sss.pgh.pa.us>
Re: distinct John McKown <joarmc@swbell.net>
I have attempted to run select distinct col1 from tablename; and it runs fine. When I run it in a real world environment: select distinct col1, col2, col3, col4 from tablename order by col1 desc, col2; It returns all the values from col1 which appears to be the same thing as not using distinct at all. Am I missing something? I'd like only distinct values on col1 and then I'll sort, include, or exclude the other columns. Andrew
В списке pgsql-general по дате отправления