Mysql select row 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 vote340 views1 answer
RowDataPacket
SQL
11 votes350 views1 answer
Oracle view ddl
SQL
2 votes356 views3 answers
Sql interview query questions
SQL
0 vote349 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote331 views1 answer
Mysql drop multiple tables at once
SQL
0 vote353 views1 answer
How to order result of subquery in select
SQL
0 vote363 views1 answer
Geopoint from json mysql function
SQL
0 vote365 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote366 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
1 vote335 views1 answer
Funzioni plsql
SQL