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 vote109 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote113 views1 answer
Mysql foreach insert
SQL
0 vote112 views1 answer
Copy value from one column to another postgres
SQL
16 votes104 views3 answers
Tsql rename column name
SQL
8 votes112 views1 answer
Sql remove leading spaces
SQL
0 vote110 views1 answer
Exclude last comma separated string mysql
SQL
8 votes103 views1 answer
Alter tablespace add datafile
SQL
4 votes144 views1 answer
Postgresql list sequences
SQL
1 vote167 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
1 vote103 views1 answer
How to between in sql
SQL