How to Use Multiple Columns in Partition By And Ensure No Duplicate Row is Returned
Try this, It worked for me SELECT * FROM ( SELECT [Code], [Name], [CategoryCode], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [IsActive], ROW_NUMBER() OVER(PARTITION BY [Code],[Name],[CategoryCode] ORDER BY ID DESC) rownumber FROM MasterTable ) a WHERE rownumber = 1