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 vote142 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote183 views1 answer
Remove from table where
SQL
1 vote172 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote204 views1 answer
Hex string sql becomes int64
SQL
13 votes178 views3 answers
Uninstall mysql centos 7
SQL
1 vote207 views1 answer
Postgresql round double precision
SQL
10 votes230 views6 answers
Mysql set root password
SQL
0 vote223 views1 answer
SQL check if record exist
SQL
0 vote204 views2 answers
Mysql insert into multiple tables
SQL
0 vote204 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL