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 vote322 views1 answer
Select first rows postgresql
SQL
0 vote290 views1 answer
Minecraft duping allowed servers
SQL
-1 vote291 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
1 vote312 views1 answer
Rails run native ssql query
SQL
1 vote321 views1 answer
Sql headers delphi
SQL
0 vote311 views1 answer
Renombrar tabla mysql
SQL
0 vote334 views2 answers
Port 5432 is already in use mac
SQL
5 votes295 views1 answer
Mysql get last day of month
SQL
0 vote305 views1 answer
Sql case when exists in another table
SQL
0 vote312 views3 answers
Sql drop all tables
SQL