last date for each user sql

1select t.username, t.date, t.value
2from MyTable t
3inner 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
8