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

14 votes144 views2 answers
Sql cast
SQL
6 votes134 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote136 views1 answer
Psql list rules
SQL
1 vote167 views1 answer
Mysql previous year
SQL
0 vote165 views3 answers
Sql parenthetical expression examples
SQL
0 vote130 views1 answer
Running query in redshift
SQL
2 votes145 views1 answer
Mysql sysdate - 1 day
SQL
0 vote142 views1 answer
Search from comma separated values in sql server
SQL
4 votes143 views1 answer
Sql delete multiple conditions
SQL
2 votes159 views1 answer
Sql count having
SQL