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 vote119 views1 answer
Mariadb datetime change to microseconds
SQL
0 vote168 views1 answer
Mysql show schema
SQL
4 votes120 views1 answer
Delete record mysql query
SQL
8 votes118 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote131 views1 answer
Search In the Data using ObjectName
SQL
0 vote153 views2 answers
Search stored procedures by name
SQL
1 vote115 views1 answer
Can we drop a primary key
SQL
0 vote125 views1 answer
How to set all the min and sec data to zero in sql server
SQL
0 vote128 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote129 views1 answer
Min salary in sql
SQL