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 vote202 views1 answer
Heidisql check how much space a row
SQL
0 vote196 views1 answer
How to select only id where is not in column mysql
SQL
0 vote201 views1 answer
Sauvegarde complète my sql
SQL
0 vote195 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote195 views1 answer
Query on date sqlite flutter
SQL
4 votes609 views1 answer
Oracle show errors
SQL
-1 vote192 views1 answer
Sql getdate date only
SQL
1 vote218 views1 answer
Postgresql round double precision
SQL
0 vote207 views1 answer
Sql list dates between two dates
SQL
0 vote205 views1 answer
Which MySQL data type to use for storing boolean values
SQL