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 vote251 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote242 views1 answer
Mysql begin statement
SQL
27 votes314 views3 answers
Mysql delete row
SQL
1 vote261 views1 answer
Top 10 rows in mysql
SQL
0 vote232 views1 answer
Declaring variables in pl sql
SQL
4 votes233 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote251 views1 answer
Sqlite closes value
SQL
15 votes458 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote260 views1 answer
Mysql where in keep order
SQL
0 vote249 views1 answer
Set default value now() date
SQL