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 vote280 views1 answer
Basic structure of sql expression having clause
SQL
3 votes257 views1 answer
Sql select all
SQL
0 vote274 views1 answer
Character count sql
SQL
17 votes272 views6 answers
Sql select distinct
SQL
0 vote309 views1 answer
Mariadb change column type
SQL
0 vote262 views1 answer
Oracle create table auto generated primary key
SQL
8 votes274 views2 answers
Phpmyadmin default password
SQL
0 vote269 views1 answer
Oracle merge insert if not exists
SQL
-1 vote316 views1 answer
How to Activate the database
SQL
2 votes252 views2 answers
Insert all in sql
SQL