删除一个表中的一些数据！

[showmetoyou]

我的表结构如下：
ID(int) CCF_NO(varchar) PRICE（varchar)
---------------------
1 1111 34242
2 1111 2334
3 2222 34334
4 2222 22343
5 2222 32425
6 1111 54544
等等！数据很多！
第一个问题：
我要把CCF_NO相同的几条数据中ID最小的一条数据删掉？请问如何做？？
第二个问题：
我要把CCF_NO相同的几条数据中PRICE最大的一条数据删掉？请问如何做？？谢谢！

[pengdali]

第一个问题：
delete 表 where id in (select min(id) from 表 group by CCF_NO)

第二个问题：

delete 表 where PRICE in (select max(PRICE) from 表 group by CCF_NO)

[txlicenhe]

delete a
from a
join (Select ccf_no,min(ID) as id from 表 group by ccf_no having count(*) > 1) b on a.id = b.id

delete a
from 表 a
join (Select ccf_no,max(ID) as id from 表 group by ccf_no having count(*) > 1) b on a.id = b.id

[txlicenhe]

1:
delete a
from 表 a
join (Select ccf_no,min(ID) as id from 表 group by ccf_no having count(*) > 1) b on a.id = b.id

2:
delete a
from 表 a
join (Select ccf_no,max(ID) as id from 表 group by ccf_no having count(*) > 1) b on a.id = b.id

[伍子V5]

1.
delete from tablename a where id=(select min(id) from tablename where CCF_NO=a.CCF_NO)
2.delete from tablename a where price=(select max(price) from tablename where CCF_NO=a.CCF_NO)

[zjcxc]

楼上几位的已经可以