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 vote150 views1 answer
Enable outgoing remote MySQL access
SQL
-1 vote147 views8 answers
Create Trigger in phpMyAdmin
SQL
0 vote174 views1 answer
MySQL get all previous date record
SQL
0 vote152 views1 answer
Mysql workbench procedure
SQL
1 vote179 views1 answer
Increase date by one day in sql oracle
SQL
1 vote171 views1 answer
Sql server set variable if exists
SQL
0 vote140 views1 answer
Postgresql alter column nullable
SQL
2 votes143 views1 answer
Sql as
SQL
3 votes146 views1 answer
Oracle list privileges
SQL
1 vote145 views1 answer
Create email address from first and last name in sql
SQL