Oracle 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 vote362 views1 answer
Multiple left join mysql
SQL
0 vote410 views1 answer
Sql show founctions
SQL
0 vote328 views2 answers
Which MySQL statement is used to delete data from a database
SQL
3 votes334 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
1 vote371 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
7 votes376 views1 answer
Query postgres delete duplicates
SQL
0 vote423 views2 answers
Suse Linux restart MySQL
SQL
0 vote365 views1 answer
Mysql query to select the highest value
SQL
3 votes347 views1 answer
Define REGEXP?
SQL
4 votes314 views1 answer
Sql list users and roles
SQL