摘要:
例如: id name value 1 a pp 2 a pp 3 b iii 4 b pp 5 b pp 6 c pp 7 c pp 8 c iii id是主键 要求得到这样的结果 id name value 1 a pp 3 b iii 4 b pp 6 c pp 8 c iii方法1 delete YourTable where [id] not in ( select max([id]) from YourTable group by (name + value)) 方法2 delete a from 表 a left join( select id=min(id) from 表 .. 阅读全文
posted @ 2013-05-29 19:37
hyyly
阅读(221)
评论(0)
推荐(0)
浙公网安备 33010602011771号