| | | |

2008年12月31日

摘要：删除重复数据一、具有主键的情况 a.具有唯一性的字段id(为唯一主键) delete table where id not in ( select max(id) from table group by col1,col2,col3... )... 阅读全文

posted @ 2008-12-31 12:38 @努力的蜗牛@ 阅读(268) 评论(0) 推荐(0)

查询和删除表中重复数据sql语句

摘要：查询和删除表中重复数据sql语句 2008-07-07 15:13 1、查询表中重复数据。select * from peoplewhere peopleId in (select peopleId from people group by peopleId having count(peo... 阅读全文

posted @ 2008-12-31 11:37 @努力的蜗牛@ 阅读(483) 评论(1) 推荐(0)