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

16 votes162 views3 answers
Order by sql query
SQL
0 vote149 views1 answer
Sql truncate table referencing itself
SQL
20 votes202 views1 answer
Get all table name in sql through php
SQL
10 votes132 views2 answers
Django mysql
SQL
1 vote232 views1 answer
Best configuration for display table in sqlplus
SQL
0 vote200 views1 answer
C# get sql min date
SQL
1 vote188 views1 answer
Get parameter value in mysql trigger
SQL
1 vote176 views1 answer
Create table variable in sql stored procedure
SQL
4 votes186 views1 answer
Datepart postgres
SQL
-1 vote178 views3 answers
SQL to LINQ converter
SQL