.net engine
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
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment