GROUP BY query in Oracle
From: Zile Liao <zliao_at_lbisoft.com>
Date: Sun, 15 Aug 1999 10:58:13 -0400
Message-ID: <7p6klj$28t$1_at_autumn.news.rcn.net>
[Quoted] [Quoted] Could anyone tell me how to group dates that are in sequence?
Date: Sun, 15 Aug 1999 10:58:13 -0400
Message-ID: <7p6klj$28t$1_at_autumn.news.rcn.net>
[Quoted] [Quoted] Could anyone tell me how to group dates that are in sequence?
[Quoted] 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 - 16:58:13 CEST