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

0 vote190 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote243 views1 answer
Mysql select row with min date
SQL
0 vote286 views1 answer
Delet all record statment sql
SQL
0 vote153 views1 answer
Now() -1 mysql
SQL
0 vote193 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
0 vote195 views1 answer
Mysql foreach insert
SQL
0 vote232 views1 answer
Mysql random number between 1 and 100
SQL
0 vote210 views1 answer
This week mysql
SQL
0 vote202 views1 answer
Shell script to log mysql cpu usage
SQL
3 votes288 views1 answer
Postgresql today - 1 year
SQL