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

2 votes279 views1 answer
How to delete columns in sql
SQL
1 vote262 views1 answer
Ora-01950 no privileges on tablespace
SQL
20 votes258 views2 answers
Counting in sql
SQL
3 votes564 views1 answer
Postgresql cast
SQL
5 votes248 views1 answer
How to check nls timestamp format in oracle
SQL
1 vote267 views1 answer
How to update date add hours in postgresql
SQL
0 vote260 views1 answer
Oracle job session
SQL
0 vote284 views1 answer
How to join result table in mysql
SQL
3 votes271 views2 answers
Sql paging query
SQL
0 vote351 views1 answer
Mysql show schema
SQL