商品和属性的条件查询sql,解决根据属性查询商品筛选，通过having实现

varphp

于 2022-01-01 02:21:57 发布

阅读量958

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库后端文章标签： sql 数据库 database

本文链接：https://blog.csdn.net/qq_22598991/article/details/122264656

后端同时被 2 个专栏收录

22 篇文章

订阅专栏

数据库

8 篇文章

订阅专栏

本文揭示了如何通过SQL查询，针对多个属性（如筛查ID 6, 7, 8）筛选出在三个属性组合下销量最高的前10商品。数据展示了商品ID、名称及对应关系ID的详细数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT
wst_jxc_goods.goodsId,
wst_jxc_goods.goodsName,
wst_jxc_screening_goods_relation.relation_id,
count(wst_jxc_screening_goods_relation.goods_id) countTmp
FROM
wst_jxc_screening_goods_relation
INNER JOIN wst_jxc_goods ON wst_jxc_goods.goodsId = wst_jxc_screening_goods_relation.goods_id
WHERE
wst_jxc_screening_goods_relation.is_delete = 0 AND
(wst_jxc_screening_goods_relation.screening_id = 6 or wst_jxc_screening_goods_relation.screening_id = 7 or wst_jxc_screening_goods_relation.screening_id = 8)
GROUP BY
wst_jxc_screening_goods_relation.goods_id having count(wst_jxc_screening_goods_relation.screening_id) = 3
LIMIT 10