Sql select row with 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 votes245 views1 answer
Mac restore mysql database command line
SQL
4 votes206 views1 answer
Sql query to make a existing column auto increment
SQL
1 vote232 views1 answer
Mysql print variable
SQL
1 vote198 views1 answer
Stored procedure return value
SQL
3 votes181 views1 answer
Pl sql check if variable is empty
SQL
-1 vote202 views1 answer
Adding a new table psql
SQL
3 votes250 views1 answer
Sql select second max
SQL
0 vote193 views1 answer
Sql server select top 2 of each group
SQL
0 vote186 views2 answers
Mysql two column combination unique
SQL
0 vote193 views1 answer
How to add session data into mysql database from button
SQL