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 vote177 views1 answer
Sql alter table add column if exists
SQL
5 votes117 views1 answer
Mysql get last day of month
SQL
0 vote135 views1 answer
Oracle archivemode
SQL
0 vote128 views1 answer
How to check default value of column in sql server
SQL
0 vote132 views1 answer
Restore backup mysql .gz
SQL
2 votes146 views2 answers
Mysql write into table
SQL
1 vote124 views3 answers
Connect to mysql c# connection string C#
SQL
0 vote134 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote139 views4 answers
Change schema in sql server
SQL
6 votes118 views2 answers
How to copy data in sql
SQL