Postgres Pro
Downloads
Home   >   mailing lists

fetch first rows of grouped data - Mailing list pgsql-sql

From Claudia Kosny
Subject fetch first rows of grouped data
Date
Msg-id 46D2FD9F.3020000@gmx.net
Whole thread Raw
Responses Re: fetch first rows of grouped data  ("D'Arcy J.M. Cain" <darcy@druid.net>)
Re: fetch first rows of grouped data  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-sql
Tree view 
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 by date:

Previous
From: Jean-David Beyer
Date:
Subject: Re: Block size with pg_dump?
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: fetch first rows of grouped data