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 vote179 views1 answer
Mysql repair a table
SQL
9 votes214 views3 answers
Date format in sql
SQL
1 vote192 views1 answer
Mysql count all table rows
SQL
9 votes184 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote309 views4 answers
Stored procedure sql
SQL
2 votes188 views1 answer
Oracle convert run_duration to number
SQL
1 vote185 views2 answers
Regex starts with
SQL
4 votes181 views1 answer
Oracle show error line number
SQL
2 votes183 views1 answer
Pdo mysql insert
SQL
9 votes201 views1 answer
Alter table column change data type to text mysql
SQL