2017/11/16

最新推荐文章于 2023-07-03 15:14:53 发布

原创最新推荐文章于 2023-07-03 15:14:53 发布 · 265 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #select #sql

平时工作中的失误总结专栏收录该内容

17 篇文章

订阅专栏

1. 当从数据库中读取到某个JdbcType.DOUBLE类型的NULL数时，如果直接返回会得到0而不会得到NULL，这是因为实体类的封装类型有误，应该用Double类型或者String类型去封装

2. 一个外链接SQL的学习

SELECT DISTINCT
    *
FROM
    (
        SELECT
            commodity.store_code AS store,
            commodity.commodity_code AS product,
            listing_amount AS listedPrice,
            sdis.discount AS plummet,
            today_amount AS currentPrice,
            cdis.discount AS productDiscount
        FROM
            ttm_store_commodity commodity
        LEFT JOIN (
            SELECT
                *
            FROM
                ttm_store_discount
            WHERE
                NOW() BETWEEN ttm_store_discount.start_time
            AND ttm_store_discount.end_time
            AND ttm_store_discount.state = '0'
        ) sdis ON commodity.store_code = sdis.store_code
        AND commodity.commodity_code = sdis.commodity_code
        LEFT JOIN (
            SELECT
                *
            FROM
                ttm_commodity_discount
            WHERE
                NOW() BETWEEN ttm_commodity_discount.start_time
            AND ttm_commodity_discount.end_time
            AND ttm_commodity_discount.state = '0'
            AND ttm_commodity_discount.pay_channel = 'wxjsapi'
        ) cdis ON commodity.store_code = cdis.store_code
        AND commodity.commodity_code = cdis.commodity_code
        WHERE
            commodity.store_code = 'd782f016-d3c8-4cc2-9dee-4d251354f252'
    ) result
ORDER BY
    product ASC