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

53 votes358 views6 answers
Sql server alter column
SQL
1 vote158 views2 answers
Mysql limit offset
SQL
2 votes196 views1 answer
Oracle trace session
SQL
1 vote142 views2 answers
Mysql current user
SQL
0 vote142 views1 answer
Create table if not exist with exceptions
SQL
4 votes145 views6 answers
Sql select statement
SQL
0 vote169 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
2 votes226 views1 answer
Postgresql group by month and year
SQL
0 vote162 views1 answer
Allow null in psql
SQL
2 votes192 views1 answer
Username sql
SQL