Friday 8 March 2013

how to get non duplicated records in sql server

with cte
as
(
select *, row_number() over (partition by userid order by id desc) RowNumber from emp_leavehistory
)

select * from cte where RowNumber =1

No comments:

Post a Comment