Skip to navigation
Find duplicates in mssql
17.07.18
SELECT s.yz3_style ,b.av0_group ,COUNT(*) AS dupes FROM [SL].dbo.yz3_stock AS s LEFT JOIN sl.dbo.av0_style AS b ON s.yz3_style = b.av0_style WHERE s.yz3_location = 1 --AND b.av0_group NOT IN ( 'MT', 'PT' ) GROUP BY s.yz3_style,b.av0_group HAVING (COUNT(*) > 1)
Reply
Anonymous
Information Epoch 1732668427
ACID (Atomicity, Consistency, Isolation, and Durability)
Home
Notebook
Contact us