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

7 votes220 views3 answers
Restore postgres database from sql file
SQL
0 vote210 views1 answer
Oracle search in date columns
SQL
22 votes242 views4 answers
Date format mysql
SQL
2 votes222 views2 answers
Change varchar length mysql
SQL
0 vote231 views1 answer
Show mysql account privilleges
SQL
5 votes223 views1 answer
Ora-00054 find lock
SQL
5 votes217 views2 answers
Oracle list columns schema
SQL
0 vote236 views2 answers
While mysql
SQL
4 votes187 views1 answer
Sql list users and roles
SQL
5 votes216 views1 answer
Ignore duplicate rows in sqlite
SQL