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

3 votes248 views6 answers
DB::table('users')->get();
SQL
1 vote219 views1 answer
Mysql batch insert
SQL
6 votes215 views4 answers
Remove spaces sql server
SQL
0 vote224 views1 answer
Mysql in clausule string array
SQL
12 votes216 views2 answers
Delete all nodes neo4j
SQL
0 vote224 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
0 vote209 views1 answer
Mysql money value
SQL
4 votes207 views2 answers
Insert current date in mysql
SQL
0 vote224 views1 answer
Sql server alter table column nullable
SQL
4 votes215 views3 answers
Sqlite show columns
SQL