Sql select row with 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 vote288 views1 answer
Mysql query to select the highest value
SQL
0 vote314 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
11 votes266 views2 answers
Import sql file laravel cmd
SQL
0 vote298 views1 answer
Gcloud sql instance list
SQL
1 vote300 views1 answer
Postgresql substring last
SQL
0 vote278 views2 answers
Select index table oracle
SQL
0 vote275 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
0 vote267 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
1 vote253 views1 answer
Update from select join
SQL
0 vote296 views1 answer
ACCEPT nome PROMPT on oracle
SQL