摘要： 经典SQL语句，便于记忆，仅供参考。1、SQL查询重复记录 Select max(id),col1,col2,COUNT(*) FromTable group by col1,col2 having COUNT(*)>12、SQL删除重得记录，仅留一条记录 delete from Table... 阅读全文