decode

最新推荐文章于 2025-04-13 23:23:09 发布

masfhs

最新推荐文章于 2025-04-13 23:23:09 发布

阅读量167

点赞数

CC 4.0 BY-SA版权

分类专栏： orcale

本文链接：https://blog.youkuaiyun.com/masfhs/article/details/80233920

orcale 专栏收录该内容

5 篇文章

订阅专栏

本文提供了一系列SQL查询案例，包括从不同角度统计特定字段的记录数量及总和，以及如何使用decode函数进行条件判断等高级技巧。

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

SELECT OPERATION_DATE,COUNT(start_pv) ,sum(start_pv) from testcount where start_pv <> 0 group by operation_date
union
SELECT OPERATION_DATE,COUNT(cart_pv),sum(cart_pv) from testcount where cart_pv <> 0 group by operation_date
union
SELECT OPERATION_DATE,COUNT(lefv_pv),sum(lefv_pv) from testcount where lefv_pv <> 0 group by operation_date
union
SELECT OPERATION_DATE,COUNT(fing_pv),sum(fing_pv) from testcount where fing_pv <> 0 group by operation_date
;
select * from testcount;

select t.operation_date,sum(t.a) from (select operation_date,start_pv, decode(sign(start_pv - 1),0,1,1,1) as a from testcount) t
group by t.operation_date;