处理数据库重复数据问题
时间：2021-07-01 10:21:17
帮助过：26人阅读
FROM c_customer_product
WHERE fid
IN
(
SELECT fid
FROM
(
SELECT fid
FROM c_customer_product
WHERE (fcustomer_id,fproduct_id,fis_delete)
IN
(SELECT fcustomer_id,fproduct_id,fis_delete
FROM c_customer_product
GROUP BY fcustomer_id,fproduct_id,fis_delete
HAVING COUNT(
*)
>1)
AND fid
NOT IN
(SELECT MIN(fid)
FROM c_customer_product
GROUP BY fcustomer_id,fproduct_id,fis_delete
HAVING COUNT(
*)
>1)
) fidresult
)
2.查找某个表中某几条记录完全相同的数据
如 ：查询 c_customer表中fdoctor_id,fhospital_id,fis_delete数据一样的记录
SELECT fid FROM
(
SELECT fid FROM c_customer
WHERE (fdoctor_id,fhospital_id,fis_delete) IN
(SELECT fdoctor_id,fhospital_id,fis_delete
FROM c_customer GROUP BY fdoctor_id,fhospital_id,fis_delete HAVING COUNT(*)>1)
AND fid NOT IN
(SELECT MIN(fid) FROM c_customer GROUP BY fdoctor_id,fhospital_id,fis_delete HAVING COUNT(*)>1)
) fidresult
处理数据库重复数据问题
标签：res bsp oct tor 完全 custom cto 查找 code
