Advertisement
yuvarajupadhyaya

latest log data of users

May 20th, 2022
682
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data Copied
Advertisement