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

14 votes269 views1 answer
Sql value of string
SQL
2 votes295 views1 answer
Datefromparts mssql
SQL
0 vote263 views1 answer
Sql developer sql worksheet not showing
SQL
4 votes242 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
1 vote273 views1 answer
Mysql select for update ejemplo
SQL
1 vote243 views1 answer
Input in mysql
SQL
0 vote241 views1 answer
Mariadb LOAD DATA INFILE
SQL
1 vote252 views1 answer
Select inside insert query
SQL
1 vote268 views1 answer
Where to locate set password for mysql
SQL
3 votes246 views2 answers
How to View column names of a table in SQL
SQL