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 vote293 views1 answer
Mysql in clausule string array
SQL
6 votes273 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
25 votes357 views5 answers
Mysql replace text
SQL
0 vote296 views1 answer
Implicit inner join table alias
SQL
0 vote268 views1 answer
Remove from table where
SQL
0 vote271 views1 answer
Pl sql search saurce code
SQL
4 votes309 views5 answers
Get last query in codeigniter 4
SQL
10 votes302 views4 answers
Primary key in sql
SQL
3 votes301 views1 answer
Unsigned int in mysql
SQL
1 vote289 views1 answer
Oracle sql average
SQL