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 vote139 views1 answer
Mysql error 1251
SQL
0 vote126 views1 answer
1 column values in to 1 single row in sql
SQL
0 vote150 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
2 votes145 views3 answers
Sql function
SQL
0 vote128 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
0 vote150 views1 answer
A network or instance-specific error sql server
SQL
1 vote121 views1 answer
How to between in sql
SQL
11 votes129 views1 answer
Oracle view source
SQL
10 votes126 views1 answer
User_dependencies
SQL
2 votes133 views1 answer
Sqlite indexes
SQL