这又一个“连续区间“的类型问题，
前面的：
SQL脚本案例【18】查询同时多地登录的用户
和本题有点类似。
解决此类问题，
诸位需要理清楚要筛选的数据，有什么特征，
筛选的条件如何处理。
“连续区间“问题，首先考虑的是 “排序”，
尤其是 “分组排序“、”开窗排序“，
排序完成后，无外乎 “求差值“、”求和“、”求比例” 等。
熟练掌握这些前面文章小编演示的技巧，
此类问题皆可以迎刃而解。
【温馨提示：建表语句及数据导入脚本，已经放在文章末尾】
题目： 查询订单详情表order_detail中，商品连续售卖的时间区间。一、需求场景
订单详情表order_detail：
正确结果：
演示工具：Hive-3.1.3 + DataGrip2022二、解决方案
“连续区间“ 问题，是绕不开 “开窗排序” 的，
本题根据商品sku_id分组排序后，可以计算每笔订单的创建日期create_date
与排序号的差值，从而筛选出连续的时间区间。
然后，通过求min、max得出连续区间的起始点即可。
【温馨提示：下面代码所涉及开窗函数 rank()，已经在前面：
详细介绍过，此处不再赘述】
（1）按照商品sku_id、下单日期create_date分组，对单日多次下单情况进行去重
select
sku_id,
create_date
from order_detail
group by sku_id, create_date结果集：
（2）按照sku_id、create_date，开窗排序
select sku_id,
create_date,
rank() over (partition by sku_id order by create_date) as rk
from (
select
sku_id,
create_date
from order_detail
group by sku_id, create_date
)t1结果集：
（3）如果存在连续日期，则连续的多个日期：create_date-rk 得出的结果一样。按照sku_id 和 这个差值分组即可
select sku_id,
min(create_date) as startDt,
max(create_date) as endDT
from (
select sku_id,
create_date,
rank() over (partition by sku_id order by create_date) as rk
from (
select
sku_id,
create_date
from order_detail
group by sku_id, create_date
)t1
)t2
group by sku_id, date_sub(create_date, rk)
结果集：
（4）代码可以进行简化，优化（1）和（2）
select sku_id,
min(create_date) as startDt,
max(create_date) as endDT
from (
select
sku_id,
create_date,
rank() over (partition by sku_id order by create_date) as rk
from order_detail
group by sku_id, create_date
)t2
group by sku_id, date_sub(create_date, rk)结果集：
三、源数据
订单详情表order_detail：
create table order_detail
(
order_detail_id string,
order_id string,
sku_id string,
create_date string,
price decimal(16, 2),
sku_num int
)
row format serde 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
with serdeproperties ('field.delim' = 't') stored as
inputformat 'org.apache.hadoop.mapred.TextInputFormat'
outputformat 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
location 'hdfs://mycluster/user/hive/warehouse/hql_test2.db/order_detail'
tblproperties ('bucketing_version' = '2');INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (‘1’, ‘1’, ‘1’, ‘2021-09-27’, 2000.00, 2);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (‘2’, ‘1’, ‘3’, ‘2021-09-27’, 5000.00, 5);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (‘3’, ‘2’, ‘4’, ‘2021-09-28’, 6000.00, 9);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (‘4’, ‘2’, ‘5’, ‘2021-09-28’, 500.00, 33);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (‘5’, ‘3’, ‘7’, ‘2021-09-29’, 100.00, 37);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (‘6’, ‘3’, ‘8’, ‘2021-09-29’, 600.00, 46);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (‘7’, ‘3’, ‘9’, ‘2021-09-29’, 1000.00, 12);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (‘8’, ‘4’, ’12’, ‘2021-09-30’, 20.00, 43);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (‘9’, ‘5’, ‘1’, ‘2021-10-01’, 2000.00, 8);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’10’, ‘5’, ‘2’, ‘2021-10-01’, 10.00, 18);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’11’, ‘5’, ‘3’, ‘2021-10-01’, 5000.00, 6);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’12’, ‘6’, ‘4’, ‘2021-10-01’, 6000.00, 8);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’13’, ‘6’, ‘6’, ‘2021-10-01’, 2000.00, 1);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’14’, ‘7’, ‘7’, ‘2021-10-01’, 100.00, 17);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’15’, ‘7’, ‘8’, ‘2021-10-01’, 600.00, 48);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’16’, ‘7’, ‘9’, ‘2021-10-01’, 1000.00, 45);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’17’, ‘8’, ’10’, ‘2021-10-02’, 100.00, 48);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’18’, ‘8’, ’11’, ‘2021-10-02’, 50.00, 15);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’19’, ‘8’, ’12’, ‘2021-10-02’, 20.00, 31);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’20’, ‘9’, ‘1’, ‘2021-09-30’, 2000.00, 9);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’21’, ‘9’, ‘2’, ‘2021-10-02’, 10.00, 5800);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’22’, ’10’, ‘4’, ‘2021-10-02’, 6000.00, 1);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’23’, ’10’, ‘5’, ‘2021-10-02’, 500.00, 24);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’24’, ’10’, ‘6’, ‘2021-10-02’, 2000.00, 5);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’25’, ’11’, ‘8’, ‘2021-10-02’, 600.00, 39);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’26’, ’12’, ’10’, ‘2021-10-03’, 100.00, 47);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’27’, ’12’, ’11’, ‘2021-10-03’, 50.00, 19);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’28’, ’12’, ’12’, ‘2021-10-03’, 20.00, 13000);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’29’, ’13’, ‘1’, ‘2021-10-03’, 2000.00, 4);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’30’, ’13’, ‘3’, ‘2021-10-03’, 5000.00, 1);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’31’, ’14’, ‘4’, ‘2021-10-03’, 6000.00, 5);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’32’, ’14’, ‘5’, ‘2021-10-03’, 500.00, 47);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’33’, ’14’, ‘6’, ‘2021-10-03’, 2000.00, 8);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’34’, ’15’, ‘7’, ‘2021-10-03’, 100.00, 20);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’35’, ’16’, ’10’, ‘2021-10-03’, 100.00, 22);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’36’, ’16’, ’11’, ‘2021-10-03’, 50.00, 42);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’37’, ’16’, ’12’, ‘2021-10-03’, 20.00, 7400);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’38’, ’17’, ‘1’, ‘2021-10-04’, 2000.00, 3);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’39’, ’17’, ‘2’, ‘2021-10-04’, 10.00, 21);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’40’, ’18’, ‘4’, ‘2021-10-04’, 6000.00, 8);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’41’, ’18’, ‘5’, ‘2021-10-04’, 500.00, 28);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’42’, ’18’, ‘6’, ‘2021-10-04’, 2000.00, 3);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’43’, ’19’, ‘7’, ‘2021-10-04’, 100.00, 55);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’44’, ’19’, ‘8’, ‘2021-10-04’, 600.00, 11);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’45’, ’19’, ‘9’, ‘2021-10-04’, 1000.00, 31);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’46’, ’20’, ’11’, ‘2021-10-04’, 50.00, 45);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’47’, ’20’, ’12’, ‘2021-10-04’, 20.00, 27);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’48’, ’21’, ‘1’, ‘2021-10-04’, 2000.00, 2);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’49’, ’21’, ‘2’, ‘2021-10-04’, 10.00, 39);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’50’, ’21’, ‘3’, ‘2021-10-04’, 5000.00, 1);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’51’, ’22’, ‘4’, ‘2021-10-05’, 6000.00, 8);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’52’, ’22’, ‘5’, ‘2021-10-05’, 500.00, 20);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’53’, ’23’, ‘7’, ‘2021-10-05’, 100.00, 58);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’54’, ’23’, ‘8’, ‘2021-10-05’, 600.00, 18);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’55’, ’23’, ‘9’, ‘2021-10-05’, 1000.00, 30);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’56’, ’24’, ’10’, ‘2021-10-05’, 100.00, 27);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’57’, ’24’, ’11’, ‘2021-10-05’, 50.00, 28);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’58’, ’24’, ’12’, ‘2021-10-05’, 20.00, 53);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’59’, ’25’, ‘1’, ‘2021-10-05’, 2000.00, 5);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’60’, ’25’, ‘2’, ‘2021-10-05’, 10.00, 35);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’61’, ’25’, ‘3’, ‘2021-10-05’, 5000.00, 9);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’62’, ’26’, ‘4’, ‘2021-10-05’, 6000.00, 1);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’63’, ’26’, ‘5’, ‘2021-10-05’, 500.00, 13);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’64’, ’26’, ‘6’, ‘2021-10-05’, 2000.00, 1);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’65’, ’27’, ‘7’, ‘2021-10-06’, 100.00, 30);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’66’, ’27’, ‘8’, ‘2021-10-06’, 600.00, 19);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’67’, ’27’, ‘9’, ‘2021-10-06’, 1000.00, 33);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’68’, ’28’, ’10’, ‘2021-10-06’, 100.00, 37);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’69’, ’28’, ’11’, ‘2021-10-06’, 50.00, 46);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’70’, ’28’, ’12’, ‘2021-10-06’, 20.00, 45);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’71’, ’29’, ‘1’, ‘2021-10-06’, 2000.00, 8);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’72’, ’29’, ‘2’, ‘2021-10-06’, 10.00, 57);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’73’, ’29’, ‘3’, ‘2021-10-06’, 5000.00, 8);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’74’, ’30’, ‘4’, ‘2021-10-06’, 6000.00, 3);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’75’, ’30’, ‘5’, ‘2021-10-06’, 500.00, 33);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’76’, ’30’, ‘6’, ‘2021-10-06’, 2000.00, 5);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’77’, ’31’, ‘8’, ‘2021-10-07’, 600.00, 13);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’78’, ’31’, ‘9’, ‘2021-10-07’, 1000.00, 43);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’79’, ’32’, ’10’, ‘2021-10-07’, 100.00, 24);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’80’, ’32’, ’11’, ‘2021-10-07’, 50.00, 30);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’81’, ’33’, ‘1’, ‘2021-10-07’, 2000.00, 8);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’82’, ’33’, ‘2’, ‘2021-10-07’, 10.00, 48);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’83’, ’33’, ‘3’, ‘2021-10-07’, 5000.00, 5);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’84’, ’34’, ‘4’, ‘2021-10-07’, 6000.00, 10);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’85’, ’34’, ‘5’, ‘2021-10-07’, 500.00, 44);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’86’, ’34’, ‘6’, ‘2021-10-07’, 2000.00, 3);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’87’, ’35’, ‘8’, ‘2020-10-08’, 600.00, 25);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’88’, ’36’, ’10’, ‘2020-10-08’, 100.00, 57);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’89’, ’36’, ’11’, ‘2020-10-08’, 50.00, 44);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’90’, ’36’, ’12’, ‘2020-10-08’, 20.00, 56);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’91’, ’37’, ‘1’, ‘2020-10-08’, 2000.00, 2);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’92’, ’37’, ‘2’, ‘2020-10-08’, 10.00, 26);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’93’, ’37’, ‘3’, ‘2020-10-08’, 5000.00, 1);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’94’, ’38’, ‘6’, ‘2020-10-08’, 2000.00, 6);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’95’, ’39’, ‘7’, ‘2020-10-08’, 100.00, 35);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’96’, ’39’, ‘8’, ‘2020-10-08’, 600.00, 34);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’97’, ’40’, ’10’, ‘2020-10-08’, 100.00, 37);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’98’, ’40’, ’11’, ‘2020-10-08’, 50.00, 51);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (’99’, ’40’, ’12’, ‘2020-10-08’, 20.00, 27);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (‘100’, ’41’, ’15’, ‘2020-10-08’, 300.00, 15);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (‘101’, ’42’, ’13’, ‘2021-01-01’, 260.00, 13);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (‘102’, ’43’, ’13’, ‘2021-01-02’, 280.00, 14);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (‘103’, ’44’, ’14’, ‘2021-01-03’, 420.00, 21);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (‘104’, ’45’, ’14’, ‘2021-01-04’, 240.00, 12);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (‘105’, ’46’, ’14’, ‘2021-09-26’, 240.00, 12);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (‘106’, ’47’, ’14’, ‘2021-10-24’, 240.00, 12);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (‘107’, ’48’, ’14’, ‘2022-09-24’, 240.00, 12);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (‘108’, ’49’, ‘1’, ‘2022-09-24’, 2000.00, 1);
INSERT INTO hql_test2.order_detail (order_detail_id, order_id, sku_id, create_date, price, sku_num) VALUES (‘109’, ’49’, ‘2’, ‘2022-09-24’, 10.00, 1);
原创文章，作者：guozi，如若转载，请注明出处：https://www.sudun.com/ask/88788.html
