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 vote330 views1 answer
Sql not equal multiple columns
SQL
0 vote331 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
25 votes406 views5 answers
Mysql replace text
SQL
6 votes399 views3 answers
What is where in sql
SQL
0 vote316 views1 answer
Mysql jdbc timezone
SQL
0 vote321 views1 answer
Php delete database
SQL
0 vote348 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote317 views2 answers
Mysql password error create datbase
SQL
8 votes354 views2 answers
Update sql server from another table
SQL
1 vote331 views1 answer
Sql server epoch to datetime
SQL