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 vote326 views1 answer
On delete set default
SQL
0 vote300 views1 answer
Mysql delete from where like
SQL
2 votes321 views1 answer
Mysql clear screen
SQL
0 vote337 views1 answer
Command line mysql xampp
SQL
0 vote305 views1 answer
Events not working db
SQL
0 vote369 views1 answer
Get substract count sql
SQL
0 vote315 views1 answer
Mysql filter based on datediff
SQL
0 vote298 views1 answer
Increment id in mysql
SQL
0 vote329 views1 answer
Find how many table doesn't contain column in mysql
SQL
0 vote321 views1 answer
Mysql isshow
SQL