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 vote277 views1 answer
Call function sql oracle with output put line
SQL
0 vote288 views1 answer
Mariadb search columns
SQL
9 votes297 views2 answers
SELECT User,Host FROM mysql.user;
SQL
0 vote261 views1 answer
Add plugins to mysql workbench
SQL
0 vote281 views1 answer
Flask sqlalchemy remove duplicates
SQL
0 vote266 views1 answer
Sql drop default
SQL
0 vote270 views1 answer
Mysql table variables
SQL
0 vote267 views1 answer
Nueva tabla mysql
SQL
17 votes276 views6 answers
Get last record in sql
SQL
0 vote299 views1 answer
Compare subqueries oracle
SQL