Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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