/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

1 vote142 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
3 votes159 views5 answers
No module named 'MySQLdb'
SQL
2 votes135 views1 answer
Oracle sql drop table purge
SQL
1 vote145 views1 answer
Sql where last 12 months
SQL
0 vote141 views1 answer
List mysql tables and views
SQL
0 vote148 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
1 vote153 views2 answers
Mysql update LAST_INSERT_ID()
SQL
0 vote147 views1 answer
Netstat -tln mysql
SQL
7 votes142 views6 answers
Nth highest salary in sql
SQL
0 vote133 views1 answer
Dasebase_url-postgres for windows
SQL