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 vote304 views1 answer
Uuid sqlalcomany
SQL
14 votes334 views1 answer
Excel
SQL
1 vote325 views2 answers
Get table column names sql laravel
SQL
13 votes299 views4 answers
Mysql get last row
SQL
0 vote308 views1 answer
Sql not exists
SQL
0 vote338 views3 answers
CONTACT FORM SQL
SQL
0 vote308 views1 answer
Sql insert tuple
SQL
3 votes302 views1 answer
Sql datetime as date
SQL
1 vote335 views1 answer
Avg mysql
SQL
2 votes363 views1 answer
Postgresql group by month and year
SQL