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 vote167 views1 answer
Get url of cpanel database hostname
SQL
5 votes184 views1 answer
Oracle list packages
SQL
0 vote186 views1 answer
Sqlite3 update select
SQL
3 votes184 views1 answer
Start mysql server by terminal in linux
SQL
11 votes351 views4 answers
Round in sql
SQL
0 vote192 views1 answer
Postgres change the name of schema
SQL
0 vote332 views1 answer
Running mysql from bash sc
SQL
0 vote203 views2 answers
Drop tables from local table database postgres
SQL
1 vote164 views1 answer
Sql myisam vs innodb
SQL
5 votes183 views4 answers
Change auto increment mysql
SQL