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

0 vote228 views1 answer
Repeatable read trong sql server
SQL
0 vote275 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote219 views1 answer
Mysql into outfile with headers
SQL
3 votes236 views2 answers
WhereIn SQL
SQL
7 votes209 views2 answers
Add column table pl sql
SQL
0 vote212 views1 answer
Where in clause tsql
SQL
42 votes276 views6 answers
Sql query duplicate rows
SQL
0 vote212 views1 answer
Primary key multiple
SQL
0 vote200 views1 answer
Postgresql where clause not working
SQL
0 vote242 views1 answer
How to check oracle index table
SQL