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 vote121 views1 answer
Oracle db create new schema
SQL
6 votes130 views2 answers
Join vs union
SQL
22 votes128 views4 answers
Mysql date_format
SQL
1 vote139 views1 answer
Last 24 HOUR data in mysql
SQL
1 vote130 views1 answer
Sql server: query to find out all the places where the table is used
SQL
1 vote141 views2 answers
Sql where is not number
SQL
0 vote138 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
0 vote132 views1 answer
Select row with latest date mysql
SQL
0 vote124 views2 answers
Update all columns in one update
SQL
0 vote132 views1 answer
Import Data in MySQL without using any other software
SQL