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

1 vote199 views1 answer
Create new table from old table with data
SQL
0 vote158 views1 answer
Sqlite update where exists
SQL
0 vote131 views1 answer
Datagrip execute procedure
SQL
0 vote118 views1 answer
SQL server select to get sum of hours
SQL
0 vote136 views1 answer
Docker open terminal mysql server
SQL
0 vote140 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
1 vote128 views1 answer
Sqlite create index
SQL
0 vote130 views1 answer
H2 auto increment and unique
SQL
0 vote132 views1 answer
Oracle search in date columns
SQL
1 vote111 views2 answers
DROP TABLes regardless of constraints
SQL