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

4 votes215 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote174 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
0 vote206 views1 answer
Postgres full text search example
SQL
0 vote175 views1 answer
How to use query in nosql
SQL
0 vote185 views1 answer
Get id if is not equal in certain table
SQL
0 vote157 views1 answer
Mysql update sequence with order by
SQL
1 vote180 views1 answer
Mysql count all table rows
SQL
0 vote232 views1 answer
Grant privileges mysql to database 1064
SQL
0 vote179 views3 answers
How to run sql query
SQL
1 vote218 views1 answer
Delete mysql ubuntu 20.04
SQL