Leetcode力扣 MySQL数据库 1532 最近三笔订单

最新推荐文章于 2024-04-19 16:26:33 发布

ziko-1101

最新推荐文章于 2024-04-19 16:26:33 发布

阅读量253

点赞数

分类专栏： Leetcode MySQL数据库（VIP）题目及解答文章标签：数据库 mysql leetcode

本文链接：https://blog.csdn.net/m0_46458212/article/details/127675249

版权

编写一个SQL查询，找出每个用户的最近三笔订单。如果用户的订单少于3笔，则返回他们的所有订单。结果按customer_name升序排列，如有相同，则按customer_id升序，再按order_date降序排列。

摘要由CSDN通过智能技术生成

1532 最近三笔订单

SQL架构

Create table If Not Exists Customers_1532 (customer_id int, name varchar(10));
Create table If Not Exists Orders_1532 (order_id int, order_date date, customer_id int, cost int);
Truncate table Customers_1532;
insert into Customers_1532 (customer_id, name) values ('1', 'Winston');
insert into Customers_1532 (customer_id, name) values ('2', 'Jonathan');
insert into Customers_1532 (customer_id, name) values ('3', 'Annabelle');
insert into Customers_1532 (customer_id, name) values ('4', 'Marwan');
insert into Customers_1532 (customer_id, name) values ('5', 'Khaled');
Truncate table Orders_1532;
insert into Orders_1532 (order_id, order_date, customer_id, cost) values ('1', '2020-07-31', '1', '30');
insert into Orders_1532 (order_id, order_date, customer_id, cost) values ('2', '2020-7-30',