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 vote234 views1 answer
Mysql view curren querys
SQL
0 vote221 views1 answer
Returning with sqlalchemy
SQL
0 vote190 views1 answer
Sql join on a subquery
SQL
0 vote153 views2 answers
Jupyter notebook connect to database
SQL
0 vote225 views1 answer
Select all same column value in sql
SQL
3 votes193 views2 answers
Mysql update row
SQL
0 vote211 views1 answer
Use where instead of join
SQL
8 votes210 views1 answer
Script to add datafile to tablespace
SQL
3 votes239 views4 answers
Mysql create table from select statement
SQL
0 vote210 views1 answer
Dataframe lambda elif
SQL