sql请教,在线等!!!急,急,急!!!!!!!

[「已注销」]

表描述:table_yyy ,两个关键字段 devid , time
devid time desc
1 20080910 xx
1 20081013 xx
1 20081021 xx
2 20080913 xx
3 20080910 xx
3 20081013 xx

需要查询出最接近当前时间的,各个设备的的记录!
查询结果
devid time desc
1 20081021 xx
2 20080913 xx
3 20081013 xx

sql语句怎么写,谢谢!

[dlpseeyou]

select * from table_yyy order by time desc

[dlpseeyou]

select * from table_yyy order by time desc

[水族杰纶]

select * from table_yyy yy where not exists(select 1 from table_yyy where devid=yy.devid and time >yy.time )

[hsie168518]

select devid max(time) as time desc from table_yyy group by devid

[昵称被占用了]

select * from table_yyy y
where not exists (
  select 1
  from table_yyy
  where devid=y.devid
  and time>y.time
  )

[hsie168518]

select * from table_yyy a,
(select devid, max(time) as time from table_yyy group by devid)b
where a.devid=b.devid and a.time=b.time

[passerbyang]

第一种
select * from table_yyy a where not exists(select 1 from table_yyy where device=a.device and time>a.time) order by desc
第二种
select * from table_yyy a where time=(select max(time) from table_yyy where device=a.device) order by desc
试试行不行吧