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

2 votes196 views1 answer
Oracle cpu per session
SQL
1 vote193 views1 answer
Importance of comment in mysql
SQL
0 vote195 views1 answer
Longtext sql
SQL
1 vote252 views1 answer
Oracle drop chain step
SQL
7 votes284 views2 answers
Phpmyadmin change password
SQL
0 vote277 views1 answer
Replace null value within column mysql
SQL
0 vote232 views1 answer
TSQL function split string
SQL
0 vote201 views1 answer
Array aggre distinct postgres
SQL
0 vote233 views1 answer
In query in sql
SQL
31 votes239 views2 answers
Grant all priviledges to mysql user
SQL