求最大時間與最小時間

[追风_GaoWu]

現在數據如下:
5028548010003 2015/12/2 19:07
5028548010003 2015/12/2 20:07
5028548010003 2015/12/2 19:31
5028548010006 2015/12/2 18:50
5028548010006 2015/12/5 10:45
5028548010007 2015/12/2 19:27
5028548010007 2015/12/4 13:09
502854801000B 2015/12/3 16:10
502854801000B 2015/12/4 13:24




想用MAX與MIN得到以下數據,請大神幫忙
5028548010003 2015/12/2 19:07 2015/12/2 20:07
5028548010006 2015/12/2 18:50 2015/12/5 10:45

[道素]

你就是想取每个值的最大和最小时间吗

with A(code,t_time) as (
select '5028548010003','2015/12/2 19:07' union
select '5028548010003','2015/12/2 20:07' union
select '5028548010003','2015/12/2 19:31' union
select '5028548010006','2015/12/2 18:50' union
select '5028548010006','2015/12/5 10:45' union
select '5028548010007','2015/12/2 19:27' union
select '5028548010007','2015/12/4 13:09' union
select '502854801000B','2015/12/3 16:10' union
select '502854801000B','2015/12/4 13:24'
) 
select a.code,min(t_time) t_min ,max(t_time) t_max from a group BY a.code