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

3 votes349 views4 answers
Mysql create table from select statement
SQL
3 votes373 views1 answer
Sql replace character in string in all records
SQL
-1 vote359 views2 answers
How to select the lowest values from table per client sql
SQL
0 vote355 views1 answer
Empty table sqlite
SQL
8 votes378 views1 answer
Ltrim sql
SQL
0 vote401 views1 answer
Sql query wordpress export post
SQL
-1 vote346 views1 answer
Mysql extract days
SQL
0 vote348 views3 answers
Find below average salary in sql
SQL
0 vote365 views2 answers
Azure sql-datenbank
SQL
0 vote355 views1 answer
Check if database exists sql
SQL