求一条SQL语句！ 各位路过的帮帮忙，不甚感谢！

[seu31199113]

求一条SQL语句！ 各位路过的帮帮忙，不甚感谢！

表结构：
编号1 编号2 时间
F01921 004 2006-05-03 00:00:00.000
F01921 004 2006-05-08 00:00:00.000
F01932 021 2006-05-03 00:00:00.000
F01932 021 2006-05-05 00:00:00.000
F01932 021 2006-05-07 00:00:00.000
F01932 005 2006-05-02 00:00:00.000
F01932 005 2006-05-03 00:00:00.000


如何用一句ＳＱＬ取出下面三条记录：

F01921 004 2006-05-08 00:00:00.000
F01932 021 2006-05-07 00:00:00.000
F01932 005 2006-05-03 00:00:00.000

即如何取得编号１、编号２组合后，最近的时间的一条记录？

[noshape]

学习....

[chusaizhe]

select top 1 编号1,编号2,时间 from 表 group by 编号1,编号2 order by 时间 DESC
这样应该也可以!

[冷箫轻笛]

select 编号1,编号2,max(时间)
from tablename
group by 编号1,编号2

[xeqtr1982]

declare @t table(编号1 varchar(10),编号2 varchar(10),时间 datetime)
insert into @t select 'F01921','004','2006-05-03 00:00:00.000'
union all select 'F01921','004','2006-05-08 00:00:00.000'
union all select 'F01932','021','2006-05-03 00:00:00.000'
union all select 'F01932','021','2006-05-05 00:00:00.000'
union all select 'F01932','021','2006-05-07 00:00:00.000'
union all select 'F01932','005','2006-05-02 00:00:00.000'
union all select 'F01932','005','2006-05-03 00:00:00.000'

select * from @t a where not exists(select 1 from @t where 编号2=a.编号2 and 时间>a.时间)

[xeqtr1982]

declare @t table(编号1 varchar(10),编号2 varchar(10),时间 datetime)
insert into @t select 'F01921','004','2006-05-03 00:00:00.000'
union all select 'F01921','004','2006-05-08 00:00:00.000'
union all select 'F01932','021','2006-05-03 00:00:00.000'
union all select 'F01932','021','2006-05-05 00:00:00.000'
union all select 'F01932','021','2006-05-07 00:00:00.000'
union all select 'F01932','005','2006-05-02 00:00:00.000'
union all select 'F01932','005','2006-05-03 00:00:00.000'

select * from @t a where not exists(select 1 from @t where 编号1=a.编号1 and 编号2=a.编号2 and 时间>a.时间)

[OracleRoob]

select 编号1,编号2,max(时间) as 时间
from tablename
group by 编号1,编号2

[子陌红尘]

--如果表中只有三个字段：
select 编号1,编号2,max(时间) as 时间 from 表 group by 编号1,编号2

--如果除了以上字段之外，还需要列出其他字段：
select a.* from 表 a where not exists(select 1 from 表 where 编号1=a.编号1 and 编号2=a.编号2 and 时间>a.时间)

[angel_bear]

楼上正解