表t_sale_record为商品销售记录表,包含如下字段:
detail_id 记录ID,
sale_date 销售日期,
province 省,
city 地市,
product_id 商品ID,
cnt 数量,
amt 金额
现查询销售商品种类超过10种的省份的记录,如下哪个语句是正确的?
选项:
A:select * from t_sale_record
where province in
(select province
from t_sale_record
group by province
having count(product_id)>10)
B:select * from t_sale_record
where province in
(select province
from t_sale_record
group by province
having count(distinct product_id)>10)
C:select * from t_sale_record
where count(product_id)>10
D:select * from t_sale_record
where count(distinct product_id)>10
发布时间:2024-07-03 00:06:01