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 vote347 views1 answer
Create bdd mysql
SQL
7 votes352 views3 answers
Add primary key to database sql
SQL
0 vote362 views5 answers
Mode sql course
SQL
0 vote352 views1 answer
How to query without duplicate rows in sql
SQL
3 votes326 views4 answers
Show columns from table
SQL
0 vote336 views1 answer
Mssql check if date is greater than today
SQL
0 vote354 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
8 votes378 views1 answer
Mysql limit rows
SQL
0 vote349 views1 answer
Inserting data into different tables at once in oracle sql
SQL
4 votes350 views4 answers
Start mysql
SQL