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 votes275 views1 answer
Drop sequence
SQL
16 votes267 views4 answers
Sort by sql
SQL
2 votes280 views1 answer
Mysql change data type of column
SQL
0 vote269 views1 answer
Mssql check if date is greater than today
SQL
0 vote263 views1 answer
Get foreign table names mysql
SQL
0 vote290 views1 answer
Sql delete caracter list
SQL
1 vote272 views1 answer
PLS-00225 type
SQL
8 votes259 views3 answers
Mysql alter table add index
SQL
3 votes274 views2 answers
Enter mysql command line
SQL
0 vote278 views4 answers
Mysql on kubernetes
SQL