sql高级

最新推荐文章于 2025-06-16 17:41:40 发布

River741132472

最新推荐文章于 2025-06-16 17:41:40 发布

阅读量402

点赞数

CC 4.0 BY-SA版权

分类专栏： java

本文链接：https://blog.youkuaiyun.com/River741132472/article/details/88579220

java 专栏收录该内容

19 篇文章

订阅专栏

1:去重查交集

select
supplier_name supplierName,
supplier_url supplierUrl,
supplier_no supplierNo,
COUNT(1) as num
from ware_supplier
where product_no in <foreach collection="productStrs" index="index" item="item" open="(" separator="," close=")">
                          #{item}
                </foreach>
and is_del = 0 and in_shop = #{inShop,jdbcType=VARCHAR} GROUP BY supplier_url,supplier_name,supplier_no HAVING num >= #{count,jdbcType=INTEGER}

2：清表语句

truncate table ware_supplier;