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 vote235 views1 answer
Mysql update set sum
SQL
0 vote245 views1 answer
Radius search with point data in mysql
SQL
0 vote217 views1 answer
Fetch second word from a string in ms sql
SQL
1 vote245 views1 answer
How to lock table in mysql
SQL
5 votes215 views2 answers
Update all rows mysql
SQL
0 vote276 views1 answer
Sql query to select even numbers
SQL
1 vote245 views1 answer
How to select the nth row in a SQL database table?
SQL
13 votes225 views3 answers
Sql select from multiple tables without join
SQL
0 vote229 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
14 votes238 views3 answers
Trim sql
SQL