SQL删除重复数据只保留一条
摘要:
一、查询全部的重复数据 select * from CHECKINOUT where userid in (select USERID from CHECKINOUT GROUP by USERID,checktime HAVING count(*)>1 ) and checktime in (se 阅读全文
posted @ 2016-03-09 16:54 梨窝★浅笑 阅读(874) 评论(0) 推荐(0) 编辑