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

3 votes433 views6 answers
Sql unique select
SQL
0 vote295 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote268 views2 answers
How to set global time_zone in mysql
SQL
8 votes279 views2 answers
Between operator
SQL
1 vote276 views1 answer
Raise application error in oracle
SQL
0 vote269 views1 answer
Php select data from mysql database without column name
SQL
0 vote274 views1 answer
How to query without duplicate rows in sql
SQL
2 votes268 views1 answer
Oracle kill job by sid
SQL
0 vote212 views1 answer
Copy table dbeaver
SQL
0 vote272 views1 answer
Sql server select record with max id
SQL