Mysql select row with min date

SELECT t1.*
FROM employees t1
INNER JOIN (
    SELECT id, min(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 vote206 views1 answer
Equi joins in oracle
SQL
14 votes241 views6 answers
Finding duplicate rows mysql
SQL
1 vote216 views1 answer
Age postgres
SQL
3 votes200 views1 answer
MySQL DELETE JOIN
SQL
0 vote196 views1 answer
Mod in sql
SQL
0 vote201 views1 answer
Update table sql multiple set
SQL
0 vote194 views1 answer
Oracle get running queries
SQL
2 votes211 views2 answers
How to add not null constraint in sql
SQL
2 votes221 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote211 views1 answer
Create schema sql server
SQL