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

8 votes147 views1 answer
Oracle search source code
SQL
0 vote154 views1 answer
Setval in postgres
SQL
0 vote185 views1 answer
DATEDIFF minute postgres
SQL
0 vote149 views1 answer
Set mysql socket file docker windows
SQL
4 votes191 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote155 views1 answer
Plsql check for string in numeric
SQL
1 vote162 views1 answer
Mysql order by desc null last
SQL
4 votes143 views2 answers
How to delete row in sql
SQL
1 vote129 views1 answer
Oracle finding duplicate records
SQL
2 votes185 views1 answer
Oracle insert or update
SQL