Postgres Pro
Downloads
Home   >   mailing lists

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

From hubert depesz lubaczewski
Subject Re: fetch first rows of grouped data
Date
Msg-id 20070828091421.GB19637@depesz.com
Whole thread Raw
In response to fetch first rows of grouped data  (Claudia Kosny <ckosny@gmx.net>)
Responses Re: fetch first rows of grouped data  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-sql
Tree view 
On Mon, Aug 27, 2007 at 06:36:47PM +0200, Claudia Kosny wrote:
> Is there a way to do this with one query?
> I am using PostgreSQL 7.4.

you can try to use "distinct on".

depesz

-- 
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: pg & Delphi
Next
From: "Sebastian Ritter"
Date:
Subject: Re: Database normalization