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 vote193 views1 answer
Sql server get date of previous sunday
SQL
5 votes174 views2 answers
Update all rows mysql
SQL
0 vote192 views1 answer
Select into table variable
SQL
0 vote180 views1 answer
Monthly Birthday SQL Query
SQL
10 votes183 views3 answers
Sql select between two dates
SQL
0 vote198 views1 answer
Postgresql find biggest table
SQL
0 vote189 views1 answer
Clear query cache sql server
SQL
0 vote270 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
11 votes184 views3 answers
Change column name sql server management studio
SQL
0 vote172 views1 answer
Nth max in my sql
SQL