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 vote293 views1 answer
Stop mysql server mac
SQL
5 votes302 views1 answer
Oracle generate list of dates in between a date range
SQL
8 votes287 views1 answer
Sql remove characters from string right
SQL
4 votes1.1K views1 answer
Oracle show errors
SQL
16 votes311 views1 answer
Mssql int max value
SQL
1 vote316 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote326 views1 answer
Oracle sql add column auto generated value
SQL
11 votes326 views5 answers
Update table from another table mysql
SQL
0 vote320 views1 answer
Mysql search like but first exact match
SQL
0 vote289 views1 answer
Trim sql oracle
SQL