Mysql select row max date

SELECT t1.*
FROM employees t1
INNER JOIN (
    SELECT id, max(job_start) AS job_start FROM employees GROUP BY id
) t2 ON t1.id = t2.id AND t1.job_start = t2.job_start;

Similar codes

2 votes138 views1 answer
Sql alchemy or
SQL
2 votes150 views1 answer
Mariadb select multiple rows into one column
SQL
0 vote154 views1 answer
How to login to mysql in homestead
SQL
0 vote144 views1 answer
Mysql subdate
SQL
0 vote186 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
0 vote189 views1 answer
How to connect to xampp sql server on windows cmd
SQL
5 votes146 views2 answers
Sql server port number
SQL
0 vote175 views1 answer
Mysql best varchar length size
SQL
0 vote157 views2 answers
Starts and end with vowel sql
SQL
0 vote137 views1 answer
Case insensitive sql
SQL