有这样1张表: 其中有两个段名namber和time.每个namber都有一个开始出现的时间和结束出现的时间,请问怎么统计出每个namber出现的开始时间和结束时间? 请高手指点
namber time
1 1996-5-6 3:00
1 1996-7-3 3:02
1 1998-5-6 3:03
3 1998-8-6 3:55
3 2001-5-6 4:10
3 2001-8-9 4:12
3 2003-5-8 4:50
6 2002-5-6 4:20
6 2005-5-6 5:00
. .
. .
. .如果现在有很多张这样的表,需要把那些信息统计到一张表上该怎么办? 请高手指点!
namber time
1 1996-5-6 3:00
1 1996-7-3 3:02
1 1998-5-6 3:03
3 1998-8-6 3:55
3 2001-5-6 4:10
3 2001-8-9 4:12
3 2003-5-8 4:50
6 2002-5-6 4:20
6 2005-5-6 5:00
. .
. .
. .如果现在有很多张这样的表,需要把那些信息统计到一张表上该怎么办? 请高手指点!
from tb
group by number
INSERT INTO Test(ID,DateTime)VALUES('1','1996-5-6 3:00')
INSERT INTO Test(ID,DateTime)VALUES('1','1996-7-3 3:02')
INSERT INTO Test(ID,DateTime)VALUES('1','1998-5-6 3:03')
INSERT INTO Test(ID,DateTime)VALUES('3','1998-8-6 3:55')
INSERT INTO Test(ID,DateTime)VALUES('3','2001-5-6 4:10')
INSERT INTO Test(ID,DateTime)VALUES('3','2001-8-9 4:12')
INSERT INTO Test(ID,DateTime)VALUES('3','2003-5-8 4:50')
INSERT INTO Test(ID,DateTime)VALUES('6','2002-5-6 4:20')
INSERT INTO Test(ID,DateTime)VALUES('6','2005-5-6 5:00') Select ID,Min(DateTime) As StartTime,Max(DateTime) As EndTime Into temp From Test
Group By ID
/*
ID StartTime EndTime
----------- ----------------------- -----------------------
1 1996-05-06 03:00:00.000 1998-05-06 03:03:00.000
3 1998-08-06 03:55:00.000 2003-05-08 04:50:00.000
6 2002-05-06 04:20:00.000 2005-05-06 05:00:00.000(3 行受影响)
*/