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

0 vote242 views1 answer
Sql get month from date
SQL
1 vote256 views1 answer
Mysql check if string contains comma separated
SQL
4 votes238 views2 answers
Bulk kill mysql processlist
SQL
0 vote256 views1 answer
How to find total working hour in sql
SQL
-1 vote255 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote255 views1 answer
What logs are available on RDS MySQL?
SQL
0 vote231 views1 answer
Mysql Error Code: 1005
SQL
25 votes238 views6 answers
Sql update query
SQL
3 votes234 views1 answer
Oracle user quota on tablespace
SQL
0 vote264 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL