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 vote117 views1 answer
Mariadb get column names from table
SQL
0 vote122 views1 answer
Delete ids between sql
SQL
0 vote267 views1 answer
Hue hive UploadingTextFiletoHive
SQL
31 votes135 views4 answers
Mysql grant execute
SQL
0 vote130 views1 answer
Sql remove non numeric characters
SQL
3 votes119 views2 answers
Mysql HAVING
SQL
0 vote88 views1 answer
Create bakupd database sqlserver
SQL
2 votes112 views1 answer
Oracle kill job by sid
SQL
1 vote138 views1 answer
OSError: mysql_config not found
SQL
0 vote114 views3 answers
Above average salary in sql
SQL