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

7 votes158 views1 answer
Alter table add key sql
SQL
1 vote216 views4 answers
Alter schema sql
SQL
1 vote195 views1 answer
DATE_SUB postgres
SQL
3 votes185 views2 answers
Oracle for loop
SQL
0 vote201 views1 answer
Mariadb number format
SQL
9 votes194 views2 answers
Sql limit order by
SQL
0 vote191 views1 answer
Delete data from database sqlite android
SQL
0 vote204 views1 answer
Postgres enumerated type
SQL
12 votes207 views4 answers
Mysql version query
SQL
2 votes197 views1 answer
Oracle list grants on procedure
SQL