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

2 votes279 views1 answer
How to make multiple keys as primary in bdms
SQL
0 vote271 views1 answer
Create mysql pool connection python flask
SQL
27 votes332 views3 answers
Mysql delete row
SQL
0 vote268 views1 answer
Export partttion and import in oracle
SQL
3 votes287 views1 answer
Postgresql today - 1 year
SQL
0 vote287 views1 answer
Remove binlog mysql
SQL
3 votes258 views2 answers
Oracle for loop
SQL
0 vote269 views1 answer
Sql remove last 2 digit
SQL
0 vote295 views1 answer
Hashpass
SQL
15 votes287 views2 answers
Select where duplicate mysql
SQL