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

33 votes339 views6 answers
Change column name in mysql
SQL
0 vote331 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
0 vote384 views2 answers
Clauses in mysql
SQL
1 vote337 views1 answer
Tsql get beginning of year
SQL
0 vote273 views1 answer
Denied
SQL
0 vote334 views1 answer
Power bi union columns
SQL
0 vote367 views1 answer
Psql check table fields
SQL
-1 vote350 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote328 views1 answer
Mysql preg replace
SQL
21 votes336 views4 answers
Oracle add column
SQL