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

0 vote345 views1 answer
Oracle running queries sql
SQL
0 vote368 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
1 vote413 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote347 views1 answer
User defined variables in sql
SQL
0 vote414 views1 answer
Python get backup of sql
SQL
1 vote295 views1 answer
Ms sql how to see active job current run time
SQL
0 vote342 views1 answer
C# datetime to sql server datetime
SQL
22 votes336 views3 answers
Sql cheat sheet
SQL
0 vote368 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote360 views1 answer
SAP Return
SQL