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

2 votes234 views2 answers
How to rename column name in sql server using query
SQL
0 vote255 views1 answer
Radius search with point data in mysql
SQL
0 vote237 views1 answer
Oracle shrink table
SQL
0 vote216 views1 answer
Select other columns with distinct
SQL
0 vote241 views1 answer
Delete * from where id = 1;
SQL
0 vote197 views1 answer
Oracle sysdba connect as another user
SQL
0 vote246 views1 answer
Postrgres trunc
SQL
0 vote248 views1 answer
Codeigniter 3 get best-selling products
SQL
0 vote235 views2 answers
Mysql password error create datbase
SQL
2 votes269 views3 answers
Xampp mysql database not starting
SQL