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

20 votes130 views3 answers
How to open postgresql in mac
SQL
0 vote157 views1 answer
Insert into table with only identity column
SQL
3 votes107 views1 answer
Oracle wait
SQL
0 vote114 views1 answer
Sql composite key
SQL
0 vote115 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote123 views1 answer
Mysql count unique in group statement
SQL
0 vote140 views1 answer
Mysql select random rows large table
SQL
1 vote111 views2 answers
Mysql current user
SQL
0 vote122 views2 answers
Find lowest number in sql
SQL
0 vote108 views1 answer
Show specific events on mysql
SQL