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 vote336 views1 answer
New rails app with mysql
SQL
1 vote276 views1 answer
Varchar plsql
SQL
1 vote305 views1 answer
Mysql add fields
SQL
1 vote285 views1 answer
Neo4j display all nodes and relationships
SQL
2 votes308 views1 answer
Set auto increment from 1
SQL
8 votes295 views1 answer
Show mysql user table
SQL
3 votes323 views2 answers
Oracle sql first day of month
SQL
2 votes294 views1 answer
Sql update alias
SQL
0 vote314 views1 answer
SQL Server date literal
SQL
12 votes322 views5 answers
Rename table in mysql
SQL