/SQL/Sql select only row with the max date

Sql select only row with the max date

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;

Sql select only row with the max date

SELECT *
  FROM situation
 WHERE datevenement = (SELECT MAX(datevenement)
                         FROM situation
                        WHERE matricule = 12)
   AND matri = 12;

Similar codes

0 vote330 views2 answers
Sql update multiple tables
SQL
0 vote354 views1 answer
Local pg_sql to heroku pg_sql
SQL
-1 vote311 views1 answer
Export mysql table to file
SQL
0 vote329 views1 answer
Sql check for null and empty string
SQL
1 vote337 views1 answer
Partition by sql server
SQL
5 votes336 views1 answer
Mysql created at yesterdau
SQL
0 vote340 views1 answer
Logtash mysql cofiguration file
SQL
8 votes326 views1 answer
Mac restore mysql database command line
SQL
0 vote323 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
1 vote317 views1 answer
Oracle aleter trigger ora-01031
SQL