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 по дате отправления
От: Mart Käsper
Дата:
Сообщение: Q : aborting requests ?
От: KMiller
Дата:
FAQ