Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.
ugh3012 Yak Posting Veteran
62 Posts
Sample DataUser ID | Date |Status001 |10/1/2013 |01001 |10/2/2013 |A1002 |1/1/2013 |BB003 |5/8/2013 |EE003 |4/2/2013 |BBExpected ResultUser ID | Date |Status001 | 10/2/2013 |A1002 | 1/1/2013 |BB003 | 5/8/2013 |EE
TG Master Smack Fu Yak Hacker
6065 Posts
select [User ID] , [Date] , [Status]from ( select [User ID] , [Date] , [Status] , rn = row_number() over (partition by [user id] order by [date] desc) from yourtable ) dwhere rn = 1
ushavellala Starting Member
10 Posts
madhivanan Premature Yak Congratulator
22864 Posts
quote:Originally posted by ushavellalaSelect distinct UserID from yourtable
SQLTeam.com Articles via RSS
SQLTeam.com Weblog via RSS
- Advertisement -
Articles
Forums
Blogs
Contact Us
About the Site