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 vote142 views1 answer
Sql myisam vs innodb
SQL
0 vote150 views1 answer
Create table database in psql
SQL
10 votes185 views2 answers
Reset mysql root password mac
SQL
5 votes163 views4 answers
Start postgres server
SQL
0 vote145 views1 answer
Difference between varchar and varchar2
SQL
0 vote167 views1 answer
Postgres clear table
SQL
1 vote142 views1 answer
Sql delete row with auto increment
SQL
2 votes162 views1 answer
Oracle sql merge
SQL
12 votes169 views5 answers
Rename table in mysql
SQL
1 vote170 views1 answer
Oracle plan hash value
SQL