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 vote203 views1 answer
Concat first name and last name in mysql
SQL
0 vote168 views1 answer
Find wordpress version in database
SQL
0 vote151 views1 answer
Sql output select
SQL
0 vote166 views1 answer
Mysql command line top 10
SQL
2 votes161 views3 answers
Sql server: how to concatenate column data using comma
SQL
6 votes130 views1 answer
Oracle trigger after connect
SQL
3 votes198 views2 answers
Mysql user permission database
SQL
3 votes138 views1 answer
Sql case update
SQL
2 votes144 views1 answer
Metasploit start postgresql
SQL
0 vote174 views1 answer
Offset in postgresql example
SQL