fetch first rows of grouped data

Поиск
Список
Период
Сортировка
От Claudia Kosny
Тема fetch first rows of grouped data
Дата
Msg-id 46D2FD9F.3020000@gmx.net
обсуждение исходный текст
Ответы Re: fetch first rows of grouped data
Re: fetch first rows of grouped data
Список pgsql-sql
Hi there

I have a list of events that take place in a certain city at a certain 
date. Now I would like to have the first two (ordered by date) events 
for each city.

Is there a way to do this with one query?
I am using PostgreSQL 7.4.

Thanks for any tips.

Claudia




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