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 vote277 views1 answer
Delete specific row in sql
SQL
7 votes281 views6 answers
Group_concat in mysql
SQL
11 votes277 views3 answers
Change column name sql server management studio
SQL
0 vote255 views1 answer
How to check replication lag in mySQL
SQL
2 votes299 views3 answers
Sql truncate table
SQL
0 vote312 views1 answer
Check if mysql db is used
SQL
2 votes267 views2 answers
Mysql get time from datetime
SQL
18 votes277 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote274 views1 answer
Psql list view rules
SQL
-1 vote266 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL