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 vote277 views1 answer
Find largest table in mysql database
SQL
1 vote284 views1 answer
Create table tablename as select * from tablename
SQL
1 vote302 views1 answer
Psql connect
SQL
0 vote287 views1 answer
Ksql quickstart docker
SQL
-1 vote366 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
0 vote294 views1 answer
Sql server pivot rows to columns
SQL
-1 vote297 views1 answer
Spring boot mysql connection properties
SQL
0 vote287 views1 answer
Make a socket server to detect changes in mysql
SQL
0 vote293 views1 answer
Oracle cpu metric
SQL
1 vote282 views2 answers
Login to mysql
SQL