Tag Info

New answers tagged

0

Here are your duplicates, then everything else is your non-duplicate. with c as ( select *, row_number() over (partition by PostSur, Name order by ID) as rowID from Aron_Reporting.dbo.Customer_NewSort ) select c.* from c inner join c c2 on c.PostSur = c2.PostSur AND c.rowID > 1 AND c2.rowID = 1 as rowID order by PostSur This ...



Top 50 recent answers are included