Q: select query

From: grk(at)usa(dot)net (G(dot) Ralph Kuntz, MD)
To: pgsql-sql(at)postgresql(dot)org
Subject: Q: select query
Date: 2003-09-12 17:58:45
Message-ID: 9881c752.0309120958.454c659c@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I am trying to write a query to select some rows.

My data consists of rows like this

1 a
1 b
1 c
2 d
3 e
3 f
...

I would like to select the second and subsequent rows where the first
column is the same:

1 b
1 c
3 f

in other words, all but the first row of a group.

Any ideas?

Thanks, Ralph

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message vijaykumar M 2003-09-13 05:46:00 createlang problme
Previous Message G. Ralph Kuntz, MD 2003-09-12 17:55:17 Q: insert/update in same statement