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 vote385 views1 answer
How to set up an anonymous function to variable in swift
SQL
3 votes362 views2 answers
Sql end of month
SQL
2 votes381 views1 answer
Postgresql create table as select
SQL
0 vote331 views1 answer
Sql cross apply vs join
SQL
2 votes384 views1 answer
Create mysql user on all hosts
SQL
0 vote335 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
0 vote360 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote363 views1 answer
Oracle service name view
SQL
-1 vote345 views1 answer
Sql oracle take only last results
SQL
0 vote364 views1 answer
Oracle execute package dblink
SQL