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 vote119 views1 answer
Select in select sql
SQL
0 vote130 views2 answers
Sql query print strings and int
SQL
3 votes123 views1 answer
How to uninstall microsoft sql server
SQL
6 votes148 views3 answers
Check if string contains substring sql
SQL
1 vote115 views1 answer
Create sample data postgresql
SQL
0 vote127 views1 answer
Convert int to varchar sql
SQL
4 votes116 views2 answers
Postgre sql create table
SQL
1 vote116 views1 answer
Join first name and last name sql
SQL
0 vote132 views1 answer
Sql server alter table column nullable
SQL
1 vote113 views3 answers
Rename table snowflake
SQL