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 vote177 views1 answer
Sql avg group by
SQL
1 vote255 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
2 votes238 views2 answers
Mysql search for column name in all tables
SQL
2 votes225 views1 answer
Pandas to sql index
SQL
0 vote196 views1 answer
Mysql get longest string in column
SQL
0 vote211 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote181 views1 answer
Azure sql server check foreign key
SQL
0 vote192 views2 answers
How to use aggregate functions in sql
SQL
21 votes249 views3 answers
Average sql
SQL
4 votes198 views1 answer
T-sql get duplicate rows
SQL