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 vote156 views2 answers
Mysql error 1215
SQL
0 vote135 views2 answers
Start mysql server using docker
SQL
0 vote147 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
0 vote154 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote160 views1 answer
Postgres full text search example
SQL
0 vote149 views1 answer
Sql combine results from two tables
SQL
0 vote141 views1 answer
Querry mysql by 2 columns
SQL
-1 vote89 views3 answers
Ubuntu install mssql
SQL
0 vote151 views1 answer
Duplix print in Smartforms
SQL
2 votes145 views1 answer
Express api ith mysql data
SQL