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 vote129 views1 answer
Double in sql server example
SQL
0 vote124 views1 answer
Call rest api from postgresql
SQL
1 vote124 views1 answer
Mysql select month and year
SQL
0 vote133 views1 answer
Mysql zerofill
SQL
0 vote139 views1 answer
Mysql type for large numbers with many decimal
SQL
0 vote125 views4 answers
First max salary in sql
SQL
27 votes144 views6 answers
Sql update record
SQL
1 vote162 views1 answer
Epoch time converter in snowflake
SQL
2 votes152 views1 answer
Insert from table tsql
SQL
2 votes137 views1 answer
Metasploit start postgresql
SQL