yuvarajupadhyaya

latest log data of users

May 20th, 2022
953
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.20 KB | None | 0 0
  1. select t.username, t.date, t.value
  2. from MyTable t
  3. inner join (
  4.     select username, max(date) as MaxDate
  5.     from MyTable
  6.     group by username
  7. ) tm on t.username = tm.username and t.date = tm.MaxDate
Advertisement
Add Comment
Please, Sign In to add comment