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 vote147 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
0 vote150 views1 answer
Running percentage of total postgres
SQL
5 votes125 views1 answer
Mysql change primary key
SQL
0 vote134 views1 answer
ORA-13717
SQL
0 vote95 views1 answer
Mysql find foreign key references
SQL
0 vote124 views1 answer
Sqldf change user
SQL
0 vote144 views1 answer
Oracle execute package dblink
SQL
0 vote142 views1 answer
Modifier une valeur sql
SQL
27 votes254 views3 answers
Mysql delete row
SQL
0 vote120 views5 answers
Sql table intermédiaire
SQL