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

0 vote174 views1 answer
H2 auto increment and unique
SQL
0 vote160 views1 answer
How to select only id where is not in column mysql
SQL
0 vote162 views1 answer
Java sql connection
SQL
2 votes155 views2 answers
Select multiple tables mysql
SQL
0 vote193 views1 answer
T sql dynamic top n query
SQL
2 votes168 views1 answer
Creating a view SQL
SQL
0 vote170 views1 answer
MySQL - How to find word with the most similar beginning
SQL
2 votes189 views2 answers
Install postgresql
SQL
0 vote178 views1 answer
Mysql join only one column
SQL
12 votes161 views2 answers
Delete all data in neo4j
SQL