SELECT SUM(CASE way WHEN 'ZFB' THEN money_amount ELSE 0 END )ZFBSUM, SUM(CASE way WHEN 'ZFBWAP' THEN money_amount ELSE 0 END ) ZFBWAPSUM, SUM(CASE way WHEN 'WX' THEN money_amount ELSE 0 END ) WXSUM, SUM(CASE way
sql case statement
The simple CASE statement has the following structure: CASE selector WHEN selector_value_1 THEN statements_1 WHEN selector_value_1 THEN statement_2 ... ELSE else_statements END CASE; Code language: PostgreSQL SQL dialect and PL/pgSQL (pgsql) Let’s examine the syntax of the simple CASE ...
SELECT Date, SUM(CASE WHEN Result='胜'THEN 1 ELSE 0 END) AS'胜', SUM(CASE WHEN Result='负'THEN 1 ELSE 0 END) AS'负'FROM Test GROUP BY Date; 3,行列转换 product_type sum_price clothes5000office600kitchen10000 sum_price_clothes sum_price_office sum_price_kitchen5000 600 10000 SELECT ...
月份,sum (case when 销售人员='姓名1' then 销售数量*产品单价 else 0 end) as 姓名1销售额,sum (case when 销售人员='姓名2' then 销售数量*产品单价 else 0 end) as 姓名1销售额,sum (case when 销售人员='姓名3' then 销售数量*产品单价 else 0 end) as 姓名1销售额 from 表格 gr...
SQL SUM With GROUP BY SQL JOINS SQL CASEThe SQL CASE statement evaluates a list of conditions and adds a column with values based on the condition. For example, -- add a new column 'order_volume' in the Orders table -- and flag any order greater than 10000 as 'Large Order' -- ...
CASE 与聚合函数 CASE语句还可以和聚合函数结合使用,下面是几个例子: CASE WHEN 和COUNT CASE WHEN 和SUM CASE WHEN 和 AVG函数 与AVG函数结合,可实现计算百分比的功能 部分例子参考来自:https://www.sqlshack.com/case-statement-in-sql 你的点赞是我持续更新的动力~ 谢谢 Thanks♪(・ω・)ノ SQL学习...
1、Using SUM, Count, MAX, DISTINCT and ORDER BY 1)The total population and GDP of Europe. SELECT SUM(population), SUM(gdp) FROM bbc WHERE region = 'Europe' 2)What are the regions? SELECT DISTINCT region FROM bbc 3)Show the name and population for each country with a population of mo...
CASE WHEN Statement Extract Data From Date — Time Columns SELF JOIN 注意:我使用的是SQLite DB浏览器和在Faker上自行创建的Dummy_Sales_Data,你可以在我的Github存储库上免费获得它! Common Table Expressions (CTE) 在处理现实生活中的数据时,有时需要查询另一...
SELECTTOP10qs.last_execution_time, st.textASbatch_text,SUBSTRING(st.TEXT, (qs.statement_start_offset /2) +1, ((CASEqs.statement_end_offsetWHEN-1THENDATALENGTH(st.TEXT)ELSEqs.statement_end_offsetEND- qs.statement_start_offset) /2) +1)ASstatement_text, (qs.total_worker_time /1000) / ...