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 vote160 views1 answer
How to delete a record from sqlite in android
SQL
0 vote161 views1 answer
Postgresql alter column nullable
SQL
0 vote170 views3 answers
How to increase size of column in sql
SQL
0 vote200 views1 answer
Sql today at midnight
SQL
0 vote162 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
0 vote123 views1 answer
'0000-00-00' for column '
SQL
6 votes166 views3 answers
How to delete table sqlite
SQL
7 votes174 views1 answer
Query postgres delete duplicates
SQL
8 votes182 views1 answer
Oracle search text in all packages
SQL
2 votes162 views1 answer
Anonymous block plsql
SQL