Mysql select row max date

SELECT t1.*
FROM employees t1
INNER JOIN (
    SELECT id, max(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

6 votes358 views1 answer
T-sql test if table exists
SQL
-1 vote349 views2 answers
How to select the lowest values from table per client sql
SQL
3 votes422 views1 answer
Where id is in list sql
SQL
0 vote346 views1 answer
Postgres sql alter table delete row
SQL
0 vote357 views1 answer
Mariadb errno 121
SQL
0 vote376 views1 answer
Oracle to_number
SQL
10 votes371 views3 answers
Join multiple tables sql
SQL
1 vote322 views1 answer
Full text index mysql
SQL
0 vote358 views1 answer
Sql server remove enter from string
SQL
-1 vote378 views1 answer
Minus vs except in sql
SQL