t1表里有四个字段 id col1 col2 col3要将col1 col2两个字段都相同的重复数据删除掉(到只剩一组)create table tmp as select max(id) as cola from t1 group by col1,col2;delete fromt1 where id not in (select cola from tmp); drop table tmp;[SQL] create table tmp as select max(id) as cola fromt1 group by col1,col2;受影响的行: 10723时间: 0.030s[SQL Read More
posted @ 2013-06-19 11:50
枫叶秋声
Views(752)
Comments(0)
Diggs(0)

浙公网安备 33010602011771号