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

1 vote284 views1 answer
Mysql select if empty result
SQL
0 vote256 views0 answer
SQL
0 vote264 views1 answer
Sql query with date
SQL
0 vote292 views1 answer
Coalesce for comma separated in sql server
SQL
0 vote299 views1 answer
Oracle table privileges
SQL
0 vote297 views1 answer
Get last three characters in mysql column
SQL
2 votes323 views1 answer
How to check if a row is null in sql
SQL
21 votes289 views6 answers
Change column in mysql
SQL
1 vote277 views1 answer
Sqlite show columns in table
SQL
0 vote276 views1 answer
Sql delete where x or y or z
SQL