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 vote143 views1 answer
Make a socket server to detect changes in mysql
SQL
0 vote159 views1 answer
Typical max-connect-errors mysql
SQL
5 votes200 views1 answer
Dbms_metadata.get_ddl table
SQL
1 vote166 views1 answer
Oracle drop job if exists
SQL
0 vote149 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
0 vote149 views1 answer
Mysql where in keep order
SQL
0 vote174 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote182 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote165 views2 answers
Mysql row_number() example
SQL
0 vote164 views1 answer
Oracle insert single quote in string
SQL