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 vote214 views1 answer
Set Mamp mysql globally
SQL
0 vote206 views2 answers
Sql server set default value equal to auto increment
SQL
1 vote215 views1 answer
Blob datatype in mysql
SQL
1 vote204 views1 answer
Mysql view current queries
SQL
9 votes233 views3 answers
Pyodbc connect to sql server
SQL
0 vote201 views1 answer
Mysql 1 hour ago
SQL
2 votes197 views1 answer
Sql get the name of user pc
SQL
1 vote201 views1 answer
Alphabetical order mysql
SQL
0 vote207 views1 answer
Geopoint from json mysql function
SQL
1 vote239 views1 answer
Create email address from first and last name in sql
SQL