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 vote186 views5 answers
Operator in sql
SQL
0 vote179 views1 answer
Psql check table fields
SQL
0 vote191 views1 answer
Excel vba import data to sql server
SQL
0 vote169 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote160 views1 answer
Partitioning in oracle-base
SQL
0 vote227 views1 answer
Suhaib
SQL
6 votes158 views5 answers
Alter table oracle
SQL
0 vote171 views1 answer
Flush user resource mysql
SQL
5 votes184 views1 answer
Oracle list days between two dates
SQL
0 vote167 views1 answer
What is metadata in sql
SQL