Sql select row with 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

2 votes226 views1 answer
Oracle log files
SQL
-1 vote196 views3 answers
Error mysql shutdown unexpectedly
SQL
1 vote207 views1 answer
Oracle nvl2
SQL
4 votes191 views2 answers
Linq join
SQL
0 vote265 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote195 views1 answer
List all functions and procedures in postgres query
SQL
1 vote287 views1 answer
How to select random rows from a table
SQL
0 vote282 views1 answer
Sql server system messeges
SQL
0 vote206 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote185 views1 answer
Sql gather statistics to increase performance
SQL