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

1 vote73 views1 answer
Pagination sql
SQL
3 votes203 views6 answers
Sql unique select
SQL
4 votes117 views3 answers
Rename table column postgresql
SQL
7 votes104 views2 answers
Create mysql user
SQL
0 vote159 views1 answer
Reindexing all tables sql server
SQL
0 vote119 views1 answer
How to use lower case in mysql
SQL
0 vote112 views2 answers
Sql if empty then
SQL
0 vote116 views1 answer
Fix sqlite3 ruby on rails
SQL
2 votes148 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
0 vote116 views1 answer
Mysql 1 hour ago
SQL