如何得到最大的數據？

[ZXYSOSO]

ID CODE
1 AAAA HI 1 0 100 2004/07/21
2 AAAA aa 1 1 100 2004/07/22
3 CCCC aa 2 1 100 2004/07/23
4 CCCC aa 2 1 100 2004/07/25
5 DDDD AAD 2 0 100 2004/07/26

以上變化是有規律的，我想得到結果如下,以CODE條件，取得ID為最大的值

2 AAAA aa 1 1 100 2004/07/22
4 CCCC aa 2 1 100 2004/07/25
5 DDDD AAD 2 0 100 2004/07/26

[hisi]

select * from 表 where id in ( select max(id) from 表 group by code )

[pbsql]

select t.* from t,(select CODE,max(ID) ID from t group by CODE) a
where t.ID=a.ID and t.CODE=a.CODE

[yesterday2000]

select a.* from tb a,(
SELECT MAX(ID) AS ID,CODE FROM tb
group by code) b
where a.id=b.id

[EthanJiang0827]

select max(id),code from x group by code

[panjinfu80]

select * from 表 where id=(select max(id) as id from 表 where code='@XX')
或
select * from 表 where id=(select max(id) as id from 表) and code='@XX'

[ZXYSOSO]

好，各位，我試下先

[zsforever]

select * from yourtable a where id = (select max(id) from yourtable b where b.code=a.code)