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

5 votes327 views4 answers
Mysql on duplicate key update
SQL
2 votes324 views1 answer
Pandas to sql index
SQL
0 vote311 views1 answer
Mysql update privileges
SQL
0 vote355 views1 answer
Joomla execute raw sql
SQL
0 vote376 views1 answer
Comparing with today and yesterday record in sql query
SQL
5 votes315 views1 answer
Ignore duplicate rows in sqlite
SQL
1 vote346 views1 answer
Mysql curdate between two dates
SQL
0 vote323 views1 answer
Show database not empty tables postgres
SQL
13 votes349 views3 answers
Change data type postgresql
SQL
5 votes304 views1 answer
Oracle asynchronous procedure
SQL