[SQL] Q: select query

[G. Ralph Kuntz, MD]

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly