怎么用SQL语句查数据库中某一列是否有重复项
怎么用SQL语句查数据库中某一列是否有重复项 SELECT SOUC_SN, COUNT(SOUC_SN) FROM med_dfr_d WHERE DFR_SOUC = ‘103’ AND VALI_FLAG = ‘1’ GROUP BY SOUC_SN HAVING COUNT(SOUC_SN) > 1 LIMIT 100;
怎么用SQL语句查数据库中某一列是否有重复项 SELECT SOUC_SN, COUNT(SOUC_SN) FROM med_dfr_d WHERE DFR_SOUC = ‘103’ AND VALI_FLAG = ‘1’ GROUP BY SOUC_SN HAVING COUNT(SOUC_SN) > 1 LIMIT 100;
共有 0 条评论