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 vote103 views2 answers
Azure sql-datenbank
SQL
2 votes227 views2 answers
MySql FULL OUTER JOIN
SQL
4 votes113 views5 answers
Primary key
SQL
4 votes117 views2 answers
Bulk kill mysql processlist
SQL
2 votes138 views2 answers
Mysql date range
SQL
0 vote103 views1 answer
Mysql trigger to delete old data
SQL
0 vote107 views1 answer
Joomla execute raw sql
SQL
1 vote113 views2 answers
Mysql trim spaces
SQL
0 vote107 views2 answers
T SQl Checking Your Username
SQL
11 votes110 views2 answers
Safe mode off mysql
SQL