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 vote216 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote259 views1 answer
Mysql trigger to delete old data
SQL
1 vote246 views3 answers
Divide by zero error in sql
SQL
1 vote262 views1 answer
Pentaho + pasar de excel a sql
SQL
1 vote233 views1 answer
Insert many to many sql
SQL
0 vote197 views1 answer
Fill up postgres db
SQL
5 votes199 views2 answers
Postgre insert select
SQL
0 vote205 views1 answer
Drop CHECK constraint sql
SQL
0 vote193 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
1 vote200 views1 answer
Postgresql convert text to float
SQL