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 vote84 views1 answer
C# datetime to sql server datetime
SQL
5 votes76 views1 answer
Sql first day of current year
SQL
0 vote108 views1 answer
Sp help text in postgresql
SQL
0 vote73 views1 answer
Alter column to not null with default value sql server
SQL
2 votes91 views1 answer
Guid to string sql
SQL
2 votes78 views1 answer
How to add where command in update comand with joins
SQL
0 vote39 views1 answer
Calculate discount from original price sql
SQL
0 vote91 views1 answer
Get from database the most recent data limit by 5
SQL
19 votes84 views5 answers
Change column name mysql command line
SQL
5 votes83 views1 answer
Oracle nls instance
SQL