SELECT a.*,a.rowid FROM T_C_RMS_CORRECT a WHERE a.res_name = 'caiAdd'
AND a.c_id IN(
SELECT b.c_id FROM T_C_RMS_CORRECT b WHERE b.res_name = 'caiAdd'
GROUP BY b.c_id HAVING COUNT(b.c_id) > 1)
删除重复的
最新推荐文章于 2021-11-21 09:51:46 发布
SELECT a.*,a.rowid FROM T_C_RMS_CORRECT a WHERE a.res_name = 'caiAdd'
AND a.c_id IN(
SELECT b.c_id FROM T_C_RMS_CORRECT b WHERE b.res_name = 'caiAdd'
GROUP BY b.c_id HAVING COUNT(b.c_id) > 1)