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 votes386 views2 answers
Mysql does sentence contain word
SQL
10 votes404 views4 answers
Join multiple tables in sql
SQL
0 vote397 views1 answer
Postgres docs /copy metacomand
SQL
8 votes364 views1 answer
How to check mysql version in xampp
SQL
1 vote327 views1 answer
Add time to date sql
SQL
1 vote364 views2 answers
Begin transaction in sql
SQL
1 vote361 views3 answers
How to truncate table with foreign key constraint
SQL
0 vote361 views1 answer
How to start my sql server on mac
SQL
1 vote346 views1 answer
Oracle create as select
SQL
0 vote372 views1 answer
Mysql 3 months ago
SQL