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

8 votes242 views3 answers
Alter user root mysql
SQL
1 vote247 views1 answer
Where to locate set password for mysql
SQL
0 vote236 views1 answer
Mariadb hours between two dates
SQL
2 votes255 views2 answers
Sqlalchemy return id after insert
SQL
0 vote239 views1 answer
Mysql drop vs delete
SQL
0 vote229 views1 answer
Arithmetic expression in sql
SQL
0 vote236 views1 answer
Recover deleted data from mysql database
SQL
-1 vote223 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
2 votes229 views3 answers
Replace null in sql
SQL
0 vote238 views1 answer
Top 3 salary in sql
SQL