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

1 vote367 views1 answer
Sqlalchemy order_by
SQL
10 votes380 views2 answers
Rtrim sql
SQL
0 vote339 views1 answer
Sql query for getting data with join and count
SQL
0 vote356 views1 answer
Get employees if not contains in sql
SQL
13 votes374 views2 answers
Sql online compiler
SQL
1 vote344 views1 answer
Sql get missing id
SQL
-1 vote372 views1 answer
Mysql select count if contains
SQL
0 vote346 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote335 views1 answer
Postgresql create table default value timestamp
SQL
2 votes363 views1 answer
Change primary key sql
SQL