How to remove duplicate rows from a table in SQL Server


SELECT OsoID, KpiMasterID,Title,StrategicPillarID , count(*)
FROM LinkKpiOsoStrategic
GROUP BY OsoID, KpiMasterID,Title,StrategicPillarID
HAVING count(*) > 1

Search This Blog

Arsip Blog

Powered by Blogger.

Recent

Comment

Author Info

Like This Theme

Popular Posts

Video Of Day

jishnukanat@gmail.com

Sponsor

Most Popular