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 vote132 views3 answers
How to run sql query
SQL
0 vote122 views2 answers
Select a row include list of array with join two table SQL
SQL
0 vote124 views1 answer
Sql get guid
SQL
0 vote131 views1 answer
Postgress append string in select
SQL
1 vote125 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
2 votes137 views2 answers
Postgres timestamp to datetime
SQL
1 vote116 views1 answer
Select dba users oracle
SQL
1 vote130 views1 answer
Sql server epoch to datetime
SQL
11 votes127 views1 answer
How to get ddl for materialized view
SQL
0 vote248 views1 answer
Android sqlite add column if not exists
SQL