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

5 votes257 views1 answer
Mongodb vs
SQL
1 vote297 views1 answer
Create new table from old table with data
SQL
0 vote290 views2 answers
Enter into postgresql database,create user and grant Access
SQL
0 vote290 views1 answer
Table or view does not exist
SQL
1 vote306 views1 answer
Oracle insert multiple rows into same table
SQL
3 votes276 views1 answer
Delete all content in table mysql
SQL
15 votes280 views4 answers
Pl sql
SQL
0 vote292 views1 answer
Como hacer una consulta en sql
SQL
4 votes302 views6 answers
Sql select statement
SQL
1 vote294 views1 answer
Is sql fast
SQL