SQL QUESTION: PLEASE HELP!!!!

I have a table wich could look like this:

table x
  ticket_number number,
  ticket_status char(1)

And the data's:

ticket_number           ticket_status
----------------------           --------------------
1                

4                               S

7                               S

and so...

You understand that the ticket_status S is for sold. So, I want a SQL which will list all tickets not sold like this:

first of group       last of group
--------------------       ---------------------
1                         3
5                         6
8                         10

Anybody know how to do this efficiently just with a SQL (no pl*sql).

Thank's!
Jean-Marc Boivin
Universite Laval
Quebec city, Canada
mail: jm_boivin_at_cti.ulaval.ca
phone: 418-656-3632 Received on Tue Jul 19 1994 - 21:27:48 CEST