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 vote179 views1 answer
Where to locate set password for mysql
SQL
0 vote161 views1 answer
Mariadb search columns
SQL
42 votes262 views6 answers
Rename table sql server
SQL
-1 vote188 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
1 vote123 views1 answer
Athena query timestamp greater than
SQL
2 votes152 views1 answer
How to delete columns in sql
SQL
10 votes225 views2 answers
Reset mysql root password mac
SQL
0 vote161 views1 answer
Set column width in sqlplus
SQL
2 votes177 views1 answer
Oracle list duplicates
SQL
5 votes170 views3 answers
Sql make column nullable
SQL