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

2 votes186 views2 answers
Mysql write into table
SQL
3 votes155 views3 answers
Mysqldump: couldn
SQL
1 vote134 views1 answer
Mysql see column types
SQL
0 vote155 views2 answers
How to know the character set of an oracle databes
SQL
0 vote195 views1 answer
Mysql subtract month from timestamp
SQL
0 vote165 views1 answer
Create sql table from script inline primary key constraint
SQL
0 vote163 views1 answer
Change magento database url usimg musql
SQL
0 vote180 views1 answer
How much space does sql server take per row
SQL
1 vote165 views1 answer
Import sql file mysql commadn line
SQL
3 votes200 views1 answer
Oracle nextval insert
SQL