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

28 votes290 views6 answers
Foreign key
SQL
1 vote188 views1 answer
Regular expression in sql server
SQL
1 vote217 views1 answer
Mysql workbench in ubuntu 14.04
SQL
0 vote199 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote259 views1 answer
Sql count matching group by
SQL
0 vote284 views1 answer
ORA-00942
SQL
1 vote198 views1 answer
What is in condition in sql
SQL
4 votes238 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
2 votes189 views1 answer
Add 2 hours to current time in MySQL
SQL
0 vote206 views1 answer
Hibernate show sql xml property
SQL