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 vote286 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote281 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
2 votes286 views1 answer
Get first n letter of department name in sql
SQL
-1 vote310 views1 answer
Search all sql tables for a value
SQL
0 vote277 views1 answer
Kill thread
SQL
2 votes267 views2 answers
Mysql all columns
SQL
1 vote303 views1 answer
Mysql show attributes of a table
SQL
0 vote273 views1 answer
Get created time of database psql 8
SQL
0 vote300 views1 answer
On delete set default
SQL
0 vote287 views1 answer
Sql server separar numeros por comas miles
SQL