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

0 vote191 views1 answer
Create a sql server database programmatically
SQL
0 vote191 views1 answer
Delete duplicate rows
SQL
0 vote209 views1 answer
MySQL import data from large CSV file
SQL
23 votes176 views6 answers
How to create table in sql
SQL
20 votes190 views1 answer
Sql change column types
SQL
0 vote176 views1 answer
Equi joins in oracle
SQL
0 vote179 views1 answer
Json_remove mysql
SQL
0 vote239 views1 answer
Postgres foreign key multiple columns
SQL
0 vote192 views1 answer
10000000000000000000 am to meters
SQL
21 votes192 views6 answers
Change column in mysql
SQL