求教一个SQL语句的写法

[xz8000]

求教一个SQL语句的写法:

我有一个设备异常日志表:TabLog
设备编号 异常时间 异常信息
ID LogTime LogInfo


我想查出所有设备最近一次的异常信息的SQL语句怎么写?

如:
1 2003-06-13 "AAAA"
1 2003-06-12 "BBBB"
2 2003-06-11 "CCCC"
2 2003-06-10 "DDDD"

查询结果:
1 2003-06-13 "AAAA"
2 2003-06-11 "CCCC"

[victorycyz]

select * from tablog inner join (select max(异常时间) as maxdate from tablog) as tabA on tablog.异常时间=taba.maxdate

[饮水需思源]

select a.* from tablog,(select ID,max(logtime) from tablog) as b
where a.ID=b.ID

[chenyu5188]

同意左手的

[xz8000]

谢谢你们的思路
我实现了
select a.* from tablog,(select ID,max(logtime) as MaxTime from tablog group by ID) as b where a.ID=b.ID and A.Logtime=B.Maxtime