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

1 vote160 views1 answer
Mysql column start with string
SQL
1 vote178 views1 answer
Oracle repeat_interval 5 minutes
SQL
9 votes152 views1 answer
Oracle get table schema
SQL
0 vote193 views1 answer
Sql server datetime
SQL
1 vote149 views1 answer
Mysql get latest duplicate rows
SQL
10 votes147 views2 answers
Tsql merge example
SQL
4 votes150 views1 answer
Phone number sql
SQL
0 vote105 views1 answer
Delete all rows from table sqlite
SQL
21 votes151 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
11 votes185 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL