查询求解

[Gordon_Chen]

Column1 Time
a 2010-11-1
a 2010-12-1
c 2010-11-1
c 2010-11-2

如何找到找出a和c对应的时间最晚的记录？
即a 2010-12-1
和c 2010-11-2

谢谢！

[快溜]

select Column1,max(Time) as Time from tb group by Column1

[叶子]

declare @tab table (Column1 varchar(1),Time datetime)
insert into @tab
select 'a','2010-11-1' union all
select 'a','2010-12-1' union all
select 'c','2010-11-1' union all
select 'c','2010-11-2'

select Column1,MAX(Time) AS [time] from @tab 
GROUP BY Column1
/*
Column1 time
------- -----------------------
a       2010-12-01 00:00:00.000
c       2010-11-02 00:00:00.000
*/