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 votes214 views2 answers
Oracle apex view logs
SQL
1 vote216 views1 answer
Postgresql contains
SQL
0 vote211 views4 answers
User defined function sql
SQL
5 votes201 views3 answers
Truncate function in sql oracle
SQL
0 vote233 views1 answer
Alter domain sql
SQL
1 vote202 views1 answer
Oracle list constraints
SQL
0 vote310 views1 answer
Sql server query all database objects
SQL
0 vote198 views1 answer
Check duplicate values plsql
SQL
1 vote216 views1 answer
Postgres regex remove special characters
SQL
8 votes189 views1 answer
How to remove tables from postgresql
SQL