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 vote141 views2 answers
Sql searching via key word
SQL
1 vote157 views2 answers
Mysql add column tinyint default 0
SQL
1 vote157 views1 answer
Encrypt password postgresql
SQL
10 votes140 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote121 views1 answer
Mysql table variables
SQL
0 vote163 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote144 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote162 views1 answer
Add new column in sql with foreign key
SQL
5 votes124 views1 answer
Mysql add user with all privileges
SQL
0 vote137 views1 answer
Oracle merge insert if not exists
SQL