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 vote95 views1 answer
Ms sql print more than 1 variable
SQL
5 votes197 views1 answer
Dbms_metadata.get_ddl table
SQL
21 votes145 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
1 vote142 views1 answer
Oracle user last connected
SQL
1 vote137 views1 answer
Mysql select month and year
SQL
7 votes151 views2 answers
Sql server drop temp table if exists
SQL
7 votes129 views1 answer
Forge server hosting
SQL
0 vote137 views1 answer
How to count null values in sql
SQL
14 votes137 views2 answers
How to auto increment in sql
SQL
1 vote156 views1 answer
Mysql select and count left join
SQL