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

1 vote380 views1 answer
Mamp mysql path mac
SQL
0 vote351 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote342 views1 answer
Oracle synonym procedure
SQL
0 vote343 views1 answer
Search In the Data using ObjectName
SQL
1 vote328 views1 answer
Mysqli connect
SQL
1 vote378 views1 answer
Mysql search like order by best match
SQL
5 votes342 views2 answers
Oracle show procedures
SQL
0 vote332 views1 answer
Mysql export data with a where clause
SQL
1 vote353 views1 answer
Oracle user last connection date
SQL
1 vote358 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL