Paresh Prajapati Commented 2 Years ago through
Interview Questions | 1 Point
you can do it with also CTE (common table expression)
;WITH cteDup
AS
(
SELECT row_number() over(partition by Employeeid, Departmentid order by Employeeid, Departmentid) as DopRw, Employeeid, Departmentid from EmployeeDeptInfo
...