34,588
社区成员
发帖
与我相关
我的任务
分享
create table czx
([date] varchar(10), [type] varchar(10))
insert into czx
select '20120101', 'ADD' union all
select '20120102', 'ADD' union all
select '20120103', 'ADD' union all
select '20120104', 'ADD' union all
select '20120102', 'MOD' union all
select '20120103', 'MOD'
select min([date]) 'date1',
max([date]) 'date2',
[type]
from czx
group by [type]
/*
date1 date2 type
---------- ---------- ----------
20120101 20120104 ADD
20120102 20120103 MOD
(2 row(s) affected)
*/