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

6 votes241 views3 answers
Psql show columns of table
SQL
10 votes161 views4 answers
Mysql one week ago
SQL
1 vote146 views1 answer
Restart identity postgresql
SQL
0 vote156 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote176 views1 answer
How to check foreign key constraint in sql
SQL
41 votes228 views6 answers
Alter table add column in SQL Server
SQL
0 vote147 views1 answer
Db format in quotation
SQL
1 vote140 views2 answers
Sql select only first occurrence
SQL
0 vote138 views1 answer
Mssql current date
SQL
10 votes155 views3 answers
Sql check double value
SQL