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

0 vote195 views2 answers
Create new table plsql
SQL
0 vote208 views1 answer
Setval in postgres
SQL
0 vote192 views1 answer
Close sql query vb.net
SQL
1 vote198 views3 answers
Union SQL
SQL
1 vote205 views1 answer
Sql padd let with zeros
SQL
0 vote265 views1 answer
Mysql remove last character
SQL
2 votes214 views1 answer
Postgresql create schema in specific database
SQL
0 vote209 views1 answer
Create table in dbms cmds
SQL
13 votes212 views2 answers
Sql join
SQL
7 votes209 views2 answers
Get database size mysql
SQL