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

0 vote200 views1 answer
How to query without duplicate rows in sql
SQL
11 votes195 views1 answer
Ddl materialized view
SQL
6 votes218 views3 answers
Date_trunc postgres
SQL
0 vote192 views1 answer
Oracle job class
SQL
0 vote161 views1 answer
Procedures and functions in pl/sql
SQL
0 vote229 views1 answer
Where date in datetime mysql
SQL
3 votes204 views2 answers
Mysql config user password
SQL
0 vote199 views1 answer
Guid string to binary better
SQL
13 votes193 views4 answers
Mysql get last row
SQL
0 vote227 views1 answer
Where to find pg_hba.conf in ubuntu
SQL