Q: select query - Mailing list pgsql-sql

From grk@usa.net (G. Ralph Kuntz, MD)
Subject Q: select query
Date
Msg-id 9881c752.0309120958.454c659c@posting.google.com
Whole thread Raw
Responses Re: Q: select query  (Rod Taylor <rbt@rbt.ca>)
Re: Q: select query  (Manfred Koizar <mkoi-pg@aon.at>)
List 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


pgsql-sql by date:

Previous
From: grk@usa.net (G. Ralph Kuntz, MD)
Date:
Subject: Q: insert/update in same statement
Next
From: chester c young
Date:
Subject: production parameters