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

26 votes431 views6 answers
Modify column name in sql
SQL
1 vote194 views1 answer
Mysql query bulk insert
SQL
0 vote185 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
0 vote172 views2 answers
Mysql two column combination unique
SQL
0 vote177 views7 answers
Les jointures sql server
SQL
1 vote187 views1 answer
Calculate age in sql postgresql
SQL
0 vote179 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote226 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
3 votes235 views2 answers
Enter mysql command line
SQL
0 vote214 views1 answer
Sqlite unique multiple columns
SQL