2016 年 9月 28 日随笔档案 - ningmou

2016年9月28日

摘要： --P_CODE 重复列 DELETE FROM Tab WHERE P_CODE IN (SELECT P_CODE FROM Tab GROUP BY P_CODE HAVING COUNT(P_CODE) > 1) AND ROWID NOT IN (SELECT MIN(ROWID) FROM Tab GROUP BY P_CODE HAVING COUNT(*) > 1); 阅读全文

posted @ 2016-09-28 11:22 ningmou 阅读(131) 评论(0) 推荐(0)