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 vote324 views1 answer
Count mysql server db tables
SQL
0 vote369 views1 answer
How to get button for every record from mysql
SQL
1 vote319 views1 answer
Sqlite3 read only
SQL
2 votes331 views2 answers
Enable foreign key checks postgres
SQL
1 vote377 views1 answer
Sql server set variable if exists
SQL
0 vote320 views1 answer
Is not sql
SQL
0 vote340 views1 answer
Typeorm raw sql
SQL
1 vote337 views1 answer
Oracle apex version view
SQL
0 vote377 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote320 views1 answer
Sqlite higher or equal
SQL