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

24 votes267 views5 answers
Import dump mysql
SQL
1 vote256 views1 answer
Mysql stop password policy
SQL
1 vote274 views1 answer
Sql group by sum with condition
SQL
0 vote271 views1 answer
Sql drop procedure if exists
SQL
2 votes281 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote347 views1 answer
Oracle db timestamp auto add
SQL
3 votes241 views1 answer
Oracle nextval
SQL
-1 vote254 views1 answer
Add column alter table default value
SQL
0 vote245 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
1 vote249 views1 answer
Sql oracle update multiple rows
SQL