[SQL] fetch first rows of grouped data

[Claudia Kosny]

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



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend