Sql select row with 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

0 vote385 views1 answer
Sql server phone constraint
SQL
20 votes344 views1 answer
Sql change column types
SQL
0 vote325 views1 answer
RowDataPacket
SQL
2 votes329 views1 answer
Set boolean flasksql
SQL
0 vote344 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
1 vote341 views1 answer
Psql search table
SQL
8 votes305 views2 answers
Phpmyadmin password
SQL
0 vote348 views1 answer
Coalesce for comma separated in sql server
SQL
1 vote321 views1 answer
Substr sql last character
SQL
0 vote337 views1 answer
Connexion mysql
SQL