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 vote178 views1 answer
Greater than or equal to symbol in postgres
SQL
0 vote182 views3 answers
Get free card roblox
SQL
-1 vote182 views3 answers
Error mysql shutdown unexpectedly
SQL
0 vote207 views1 answer
Second Step in installing SQL workbench
SQL
0 vote217 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
0 vote220 views1 answer
Get initial in sql
SQL
0 vote210 views1 answer
Oracle INTERVAL DAY to second to number
SQL
23 votes176 views6 answers
How to create table in sql
SQL
0 vote207 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
1 vote182 views1 answer
Generate random data postgresql
SQL