select * from ( select distinct KOD, count(*) over (partition by KOD) Tekrar_Sayisi FROM [CAGLAYAN_WEB].[dbo].[WEB_URUN] ) kayit where Tekrar_Sayisi > 1 KOD Tekrar_Sayisi DCD700C2 8 DCD732D2 8 DCD734S2 8 DCD996P2 8 DCF880M2 8 SCD12S2K 8 STDH7213CK 8 STHT1-77139 8 STSJ0600K 8 URN.CYN.003 8 URN.CYN.004 8 URN.CYN.005 8 URN.KPK.002 8
Hiç yorum yok:
Yorum Gönder