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

3 votes157 views1 answer
System.debug apex
SQL
0 vote195 views1 answer
Drop a field in psql django
SQL
0 vote244 views1 answer
T-SQL Create Trigger
SQL
1 vote190 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote198 views1 answer
Sql shell psql cannot enter password
SQL
0 vote215 views1 answer
How to create a table in sql stack overflow
SQL
0 vote210 views1 answer
Mssql + bit + in python orm
SQL
3 votes205 views1 answer
Oracle limit user tablespace
SQL
10 votes209 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote215 views1 answer
Sql remove non numeric characters
SQL