Kiểm tra trùng dữ liệu trong sqlsever

Question

SELECT makien, COUNT(*) AS dupes
FROM tbl_nhaplieu_wc
GROUP BY makien
HAVING (COUNT(*) > 1)

Answer 1

SELECT *
FROM tbl_nhapphieu_dinhphoi
WHERE sttqr IN (
SELECT sttqr
FROM tbl_nhapphieu_dinhphoi
GROUP BY sttqr, loai, vaora
HAVING COUNT(sttqr) > 1
)
ORDER BY ngaynhap DESC