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 vote187 views1 answer
Sql server 2012 create or alter procedure
SQL
1 vote265 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
28 votes154 views6 answers
Distinct sql
SQL
0 vote141 views1 answer
Ms sql print more than 1 variable
SQL
1 vote195 views2 answers
Pl sql case
SQL
3 votes184 views1 answer
Oracle rollback
SQL
10 votes246 views6 answers
Mysql set root password
SQL
18 votes182 views3 answers
Mysql add column with default value
SQL
3 votes194 views1 answer
How to check schema privileges in oracle
SQL
0 vote195 views1 answer
Get primary key of table
SQL