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

10 votes217 views3 answers
Sql check double value
SQL
16 votes215 views1 answer
Mssql int max value
SQL
0 vote164 views1 answer
Ms sql print more than 1 variable
SQL
0 vote215 views1 answer
Database xml sql
SQL
12 votes244 views6 answers
Change mysql root password
SQL
3 votes255 views1 answer
Oracle undo tablespace schema
SQL
3 votes223 views1 answer
Unsigned int in mysql
SQL
0 vote212 views1 answer
Database timezone
SQL
0 vote225 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote205 views2 answers
Check mysql timezone
SQL