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 vote334 views2 answers
Oracle select
SQL
0 vote324 views2 answers
SQL BULK INSERT
SQL
0 vote328 views2 answers
How to tun mysql on ubunto
SQL
8 votes346 views1 answer
Ltrim sql
SQL
1 vote344 views1 answer
What is a Database?
SQL
0 vote329 views1 answer
Sql get number of days between two dates
SQL
0 vote330 views1 answer
T-SQL Never ending DELETE
SQL
-1 vote323 views1 answer
Su: Authentication failure mysql
SQL
1 vote317 views1 answer
Sql server update column based on another table
SQL
6 votes318 views1 answer
Check Table Exists
SQL