Remove duplicate rows

Поиск
Список
Период
Сортировка
От Jiří Němec
Тема Remove duplicate rows
Дата
Msg-id 476854341.20070111185157@menea.cz
обсуждение исходный текст
Ответы Re: Remove duplicate rows
Re: Remove duplicate rows
Список pgsql-general
Hello,

I need to remove duplicates rows from a subquery but order these
results by a column what is not selected. There are logically two
solutions but no works.

SELECT DISTINCT sub.foo FROM (SELECT ...) AS sub ORDER BY sub.bar
ERROR:  for SELECT DISTINCT, ORDER BY expressions must appear in select list

SELECT sub.foo FROM (SELECT ...) AS sub GROUP BY sub.foo ORDER BY sub.bar
ERROR: column "sub.bar" must appear in the GROUP BY clause or be used
in an aggregate function

Does anybody know how to remove duplicate rows from a subquery and order
these results by a column what is not selected but exists in a subquery?

Thanks for any advice,

J.N.


В списке pgsql-general по дате отправления: