Mysql select row with min date

SELECT t1.*
FROM employees t1
INNER JOIN (
    SELECT id, min(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 vote155 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote134 views1 answer
Dasebase_url-postgres for windows
SQL
1 vote153 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
3 votes142 views2 answers
To_char sql
SQL
0 vote149 views1 answer
Can we rollback in sql
SQL
0 vote138 views1 answer
Full syntax inner join
SQL
9 votes166 views4 answers
Last mysql
SQL
32 votes155 views6 answers
Sql count where
SQL
0 vote144 views1 answer
Oracle locked objects
SQL
0 vote150 views7 answers
Les jointures sql server
SQL