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

11 votes189 views4 answers
Update row in mysql
SQL
0 vote185 views1 answer
Mysql preg replace
SQL
0 vote180 views1 answer
Add alternate add column sql
SQL
2 votes184 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
0 vote140 views1 answer
Select all domains of database firbird
SQL
2 votes189 views1 answer
Sql update from different table
SQL
0 vote182 views4 answers
Mysql on kubernetes
SQL
1 vote215 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
1 vote177 views1 answer
Pv mysql import
SQL
28 votes134 views6 answers
Distinct sql
SQL