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 vote362 views1 answer
Mysql drop vs delete
SQL
0 vote361 views1 answer
Sql select with apostrohpe
SQL
0 vote392 views1 answer
Get clob size oracle
SQL
0 vote417 views1 answer
Tsql cte in a transaction
SQL
2 votes315 views1 answer
Mysql admin u root p password change password
SQL
8 votes352 views1 answer
Database backup in mysql server recovery
SQL
0 vote406 views1 answer
Acutal month year
SQL
1 vote375 views1 answer
Sql order by where condition
SQL
7 votes419 views3 answers
Sql server check if temp table exists
SQL
0 vote365 views1 answer
How many rows affected in sqllite
SQL