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 vote154 views1 answer
Oracle plan hash value
SQL
11 votes187 views2 answers
You are using safe update mode
SQL
1 vote147 views1 answer
Postgres format date in select
SQL
0 vote131 views1 answer
Mysql count grouped rows
SQL
0 vote159 views1 answer
Time data type in mysql
SQL
0 vote131 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote133 views1 answer
Cannot pip install mysqlclient
SQL
19 votes153 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
2 votes131 views3 answers
How to pass password mysql command line
SQL
3 votes134 views1 answer
Two select sql
SQL