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

23 votes213 views4 answers
How to show all users in mysql
SQL
0 vote198 views2 answers
Transaction php
SQL
18 votes190 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
1 vote189 views1 answer
Delete mysql from mac
SQL
0 vote200 views1 answer
How to select all fieldsin a soql query
SQL
0 vote184 views1 answer
Get records in sql according to month name and count
SQL
0 vote191 views1 answer
How to get initials in sql
SQL
4 votes183 views3 answers
Order by value mysql
SQL
0 vote255 views1 answer
Php insert null mysql
SQL
2 votes193 views1 answer
Brew start postgres manual
SQL