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 vote137 views1 answer
Mysql select utc time in eastern time
SQL
1 vote198 views1 answer
Oracle see column type
SQL
37 votes325 views3 answers
Sql check duplicate value in column
SQL
2 votes141 views3 answers
Postgresql reset auto increment
SQL
1 vote134 views2 answers
Group_concat limit mysql
SQL
1 vote143 views2 answers
Procedure syntax
SQL
1 vote173 views2 answers
Laravel jwt generate token
SQL
0 vote131 views1 answer
Console output pl sql
SQL
1 vote131 views1 answer
Show table columns
SQL
5 votes131 views1 answer
Invalid column name sql
SQL