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

1 vote191 views2 answers
Sql select only first occurrence
SQL
2 votes207 views1 answer
Sqlite3 show columns name
SQL
9 votes216 views6 answers
Oracle substring
SQL
0 vote204 views1 answer
How to install postgresql on wsl
SQL
2 votes190 views1 answer
Update with join sql server
SQL
0 vote187 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote200 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
1 vote190 views1 answer
Input in mysql
SQL
0 vote192 views2 answers
Sqlite
SQL
7 votes173 views1 answer
Mysql load data infile csv
SQL