SELECT T0.[ItemCode], T0.[U_HCLength] FROM PQT1 T0
WHERE T0.[DocEntry] =#1
GROUP BY T0.[ItemCode], T0.[U_HCLength] having count(*) > 1
本站内容多数为佳明one原创,少量转载自网络。
- 本文标题:SQL查询重复记录
- 本文地址:https://itjm.com/2014/05/SQL,重复数据.html
SELECT T0.[ItemCode], T0.[U_HCLength] FROM PQT1 T0
WHERE T0.[DocEntry] =#1
GROUP BY T0.[ItemCode], T0.[U_HCLength] having count(*) > 1