《学习MySQL语句》——第十五天

shawn&lycheeo

于 2023-04-23 13:43:03 发布

阅读量44

点赞数

文章标签： sql mysql 数据库学习

本文链接：https://blog.csdn.net/qq_40911499/article/details/130319857

版权

# Write your MySQL query statement below

select product.product_id, ifnull(newprice.new_price, 10) as price
from 
    (
        select distinct product_id
        from Products
    )as product left join
    (
        select product_id, new_price
        from Products
        where (product_id, change_date) in
        (
            select product_id, max(change_date)
            from Products
            where change_date <= '2019-08-16'
            group by product_id
        ) 
    )as  newprice
on product.product_id = newprice.product_id


#IFNULL(x1, x2) ：如果 x1 为 NULL， 返回 x2，否则返回 x1。