Answer: WITH temp_Table as
(
SELECT ROW_NUMBER() Over(PARTITION BY FirstName,LastName,PAN_No ORDER BY FirstName) As RowNumber,*
FROM Employee_Master;
)
DELETE FROM temp_Table where RowNumber >1;
SELECT * FROM Employee_Master order by FirstName asc;
Asked In: Many Interviews |
Alert Moderator