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 vote172 views1 answer
Sql date between one week
SQL
20 votes191 views6 answers
Change password in mysql
SQL
0 vote169 views1 answer
The local psql command could not be located
SQL
1 vote189 views1 answer
Raise application error in oracle
SQL
23 votes217 views6 answers
Create table sql
SQL
0 vote179 views1 answer
Select from 3 tables one is empty
SQL
0 vote176 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
0 vote238 views1 answer
Mysql row generator
SQL
0 vote229 views1 answer
Sql to excel pgadmin
SQL
0 vote172 views1 answer
Oracle locked objects
SQL