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 vote94 views5 answers
Sql table intermédiaire
SQL
0 vote99 views1 answer
Dns slave zone convert
SQL
0 vote106 views1 answer
Postgresql on conflict pair
SQL
5 votes93 views1 answer
Oracle get nls settings
SQL
5 votes166 views1 answer
Oracle asynchronous procedure
SQL
0 vote103 views1 answer
Mssql now diff 90 day
SQL
0 vote63 views1 answer
Sql count how many times a value appears
SQL
0 vote100 views1 answer
Hive batch drop table
SQL
0 vote105 views1 answer
Narural join
SQL
2 votes146 views3 answers
Mysql kill
SQL