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 vote374 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote361 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
11 votes374 views4 answers
MYSQL LOGIN
SQL
-1 vote353 views3 answers
Error mysql shutdown unexpectedly
SQL
0 vote332 views1 answer
SQL get max per id
SQL
0 vote362 views1 answer
Sql join on a subquery
SQL
0 vote359 views1 answer
Creating a simple notify in postgresql
SQL
0 vote344 views1 answer
Exclude last comma separated string mysql
SQL
3 votes333 views1 answer
Search for column name in psql
SQL
1 vote358 views1 answer
Error code 1292 mysql workbench
SQL