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 vote237 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
11 votes233 views4 answers
MYSQL LOGIN
SQL
2 votes231 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote228 views1 answer
Create table with timestamp mysql youtube
SQL
0 vote228 views1 answer
Sql order by number not ordered
SQL
0 vote229 views1 answer
Delete record by id sql
SQL
0 vote230 views1 answer
Mysql root localhost run
SQL
1 vote225 views1 answer
How to find median of a column sql
SQL
10 votes180 views2 answers
Django mysql
SQL
0 vote221 views1 answer
NLS_NCHAR_CHARACTERSET
SQL