Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select t.username, t.date, t.value
- from MyTable t
- inner join (
- select username, max(date) as MaxDate
- from MyTable
- group by username
- ) tm on t.username = tm.username and t.date = tm.MaxDate
Advertisement
RAW Paste Data
Copied
Advertisement