SQL select case

最新推荐文章于 2022-03-09 12:30:17 发布

iteye_6188

最新推荐文章于 2022-03-09 12:30:17 发布

阅读量121

点赞数

CC 4.0 BY-SA版权

分类专栏： SQL相关

本文链接：https://blog.youkuaiyun.com/iteye_6188/article/details/82449189

SQL相关专栏收录该内容

1 篇文章

订阅专栏

本文详细解析了特定时间段内，不同供应商ID、商品ID、商家ID下的销售数据，通过条件筛选与分组聚合，揭示了商品分类与销售趋势的关系。分析了包括BestBuy、Replink、Buy.com等知名电商平台的销售表现，提供了对电子商务业务策略制定的参考。

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

select var_id, program_id, case merchant_id
when '200' then 'bestbuy'
when '300' then 'Replink'
when '500' then 'Buy.com'
when '30000' then 'ALMO'
when '30025' then 'BabyAge.com'
when '30050' then 'Bambeco'
when '30225' then 'cooking.com'
when '30060' then 'Bass Pro Shops'
when '30225' then 'Cooking.com'
when '30300' then 'Discount Golf World'
when '30355' then 'DSI Systems'
when '30360' then ' eBags'
when '30455' then ' Petra'
when '30475' then 'Sears'
when '30575' then 'ShoeBuy.com'
when '30585' then 'ShoppersChoice.com'
when '30825' then ' Unbeatable'
when '30830' then 'Mercent'
when '30850' then 'Premco'
when '70000' then 'Koinz'
else merchant_id
end
,count(*) as count from order_line
where create_date<='2011-10-25' and create_date>='2011-06-01' and supplier_id='200' and var_id in('b2s_qa','B2S_LIVE' ) and order_status<>'11'
group by var_id, program_id, merchant_id
order by var_id, program_id, merchant_id