使用Case when 去判断某个字段值不同时执行各自查询

最新推荐文章于 2024-01-17 11:05:32 发布

cgggdddddd

最新推荐文章于 2024-01-17 11:05:32 发布

阅读量763

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/cgd_8523/article/details/103805655

版权

mysql 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

<select id="getBySku" resultMap="BaseResultMap" parameterType="java.util.HashMap">
        SELECT
            <include refid="Base_Column_List"/>,
            case when change_no not like "DO%" then (
                select DISTINCT
                case when uo.parent_order_no > 0 then uo.parent_order_no
                else uo.order_no
                end orderNo
                from uo_order uo
                where uo.order_no = pr.change_no
            )
            else (
                select DISTINCT
                    case when uo.parent_order_no > 0 then uo.parent_order_no
                    else uo.order_no
                    end orderNo
                from uo_order_bill uob
                left join uo_order uo
                on uob.order_no=uo.order_no
                where uob.business_order_no = pr.change_no
            )
            end orderNo
        FROM pd_stock_change_record pr
        <where>
          <if test="skuCode != null and skuCode != ''">
              and sku_code = #{skuCode}
          </if>
          <if test="inOutStock != null">
             and in_out_stock = #{inOutStock}
          </if>
          <if test="type != null">
             and type = #{type}
          </if>
        </where>
        order by create_time desc
    </select>