求SQL!(在线等)

[zhouyuzzzzzz]

表TABLE:
ID DATE MSG
001 20080801 11
001 20080802 22
002 20080803 33

要得到结果:(取ID相同的时间最大的MSG)
001 22
002 33

这个SQL怎么写???

[fzcheng]

SELECT * FROM tb a
WHERE NOT EXISTS (SELECT 1 FROM tb WHERE ID=a.ID AND MSG>a.MSG )

[Yang_]

select id,max(msg) as msg
from [table]
group by id

[等不到来世]

select ID,MSG 
from tb a
where not exists(select 1 from tb where ID=a.ID and DATE>a.DATE)

[ws_hgo]

等下

[ccjjww1222]

[Quote=引用 2 楼 Yang_ 的回复:]
SQL codeselect id,max(msg) as msg
from [table]
group by id
[/Quote]