Last date for each user sql

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

Source: stackoverflow.com

Similar codes

1 vote245 views1 answer
Oracle check table lock
SQL
0 vote190 views1 answer
Sql server express download
SQL
0 vote186 views1 answer
Sqlite update only if greater
SQL
4 votes190 views1 answer
Oracle error compilation line
SQL
8 votes193 views6 answers
Sql insert
SQL
1 vote204 views1 answer
Mysql dump specific tables
SQL
8 votes214 views1 answer
My sql version
SQL
15 votes191 views1 answer
Mysql int range
SQL
0 vote267 views1 answer
Restart serial number for postgres
SQL
2 votes192 views1 answer
Update trigger
SQL