Unique - first

Поиск
Список
Период
Сортировка
От Robert James
Тема Unique - first
Дата
Msg-id CAGYyBgjdOCm-OJ7D-2TP8_417f8U5tgKJrtE0q=m_nSFjFsAEg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Unique - first
Re: Unique - first
Re: Unique - first
Список pgsql-general
I have a table (x,y,z) - I'd like to take the rows with unique x
values - but, when more than one row have the same x value, I want the
one with the minimal z value.

How can I do that? I can imagine doing it with window functions, but
also that regular SQL should be able to do it too.


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