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 vote348 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote348 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote333 views1 answer
Connect to ssms with python
SQL
3 votes335 views2 answers
Oracle grants
SQL
0 vote322 views1 answer
Sqlite closes value
SQL
0 vote350 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote340 views1 answer
Mysql url data type
SQL
0 vote350 views1 answer
Mysql set variable to today's date
SQL
0 vote336 views1 answer
Two inner joins sql
SQL
0 vote426 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL