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 vote105 views1 answer
Import database from a file using mysql commandline
SQL
0 vote98 views1 answer
Resulting Query
SQL
0 vote114 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
0 vote108 views1 answer
Mysql subdate
SQL
0 vote125 views1 answer
Time data type in mysql
SQL
3 votes100 views1 answer
Oracle detect invalid password
SQL
0 vote113 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
1 vote99 views4 answers
Aggregate function in sql
SQL
0 vote101 views1 answer
Group by two columns postgres
SQL
0 vote109 views1 answer
SQL check if record exist
SQL