 |
WITH tempTable as
(
SELECT ROW_NUMBER() Over(PARTITION BY Name,Position ORDER BY Name) As RowNumber,* FROMEmployeData
)
SELECT * FROM tempTable
|
Once we run above query we will get data like this
 |
If you observe above table I added another column RowNumber this column is used to know which record contains duplicate values based on rows with RowNumber greater than 1.
Now we want to get the records which contains unique value from datatable for that we need to write the query like this
WITH tempTable as
(
SELECT ROW_NUMBER() Over(PARTITION BY Name,Position ORDER BY Name) As RowNumber,* FROMEmployeData
)
DELETE FROM tempTable where RowNumber >1
SELECT * FROM EmployeData order by Id asc
|
 |
Sign up here with your email
ConversionConversion EmoticonEmoticon