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 vote279 views1 answer
Sqlite3 read only
SQL
0 vote301 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote273 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote267 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote287 views2 answers
SQL FROM
SQL
1 vote336 views1 answer
Import sql file from laravel
SQL
0 vote293 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
3 votes305 views1 answer
Sql case update
SQL
1 vote298 views1 answer
Best sql course
SQL
0 vote303 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL