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 vote294 views1 answer
See the structure of a table mysql
SQL
0 vote265 views1 answer
Get the Db column names from a SqlDataReader
SQL
0 vote262 views1 answer
Sql change date format
SQL
0 vote274 views1 answer
How to search query in python3 sqlite3
SQL
0 vote265 views1 answer
Mysql changer nom table
SQL
4 votes256 views1 answer
Adding data to table in sql python
SQL
1 vote275 views1 answer
Add multiple row table pl sql
SQL
0 vote291 views1 answer
SQLServerException.makeFromDatabaseError
SQL
2 votes259 views1 answer
Merge two columns in sql oracle
SQL
0 vote279 views1 answer
Find how many tables in database sql query
SQL