GROUP BY query in Oracle

Could anyone tell me how to group dates that are in sequence?

My data looks like the following:

111-11-1111      1/1/99
111-11-1111      1/2/99
111-11-1111      1/3/99
111-11-1111      2/1/99
111-11-1111      2/2/99
111-11-1111      2/3/99
222-22-2222      1/1/99
222-22-2222      1/2/99
222-22-2222      1/3/99

When I used the following statement:

SELECT ssn, MIN(date_field), MAX(date_field) FROM tbl GROUP BY ssn

It returned

111-11-1111      1/1/99      2/3/99
222-22-2222      1/1/99      1/3/99

I would actually like to get 3 records back as the following:
111-11-1111      1/1/99      1/3/99
111-11-1111      2/1/99      2/3/99
222-22-2222      1/1/99      1/3/99

Could anyone tell me if it is possible?

Thanks alot!!!!!

Zile Liao
zliao_at_lbisoft.com Received on Sun Aug 15 1999 - 09:58:13 CDT