我需要選擇 sum() 產生的最大值
SELECT
row_data->>'companyName' AS "NOME EMPRESA",
count(row_data->>'companyName') AS "Count" ,
sum((row_data->>'bankMovementAmount')::float 0.0) AS "VALOR S"
FROM public.teste
where abbreviation = 'BMO' AND row_data->>'bankMovementOperationType'= 'S'
GROUP BY row_data->>'companyName'
ORDER BY row_data->>'companyName' ASC;
有誰知道如何幫助我，從（選擇）中選擇
如何過濾演員退出進入
bankMovementOperationType'='S'退出
bankMovementOperationType'= 'E' 進入
sum((row_data->>'bankMovementAmount')::float 0.0) AS "VALOR S"
在此處輸入影像描述
uj5u.com熱心網友回復：
您可以使用條件乘法器
SUM(
(row_data->>'bankMovementAmount')::float
* (CASE row_data->>'bankMovementOperationType'
WHEN 'S' THEN -1.0
WHEN 'E' THEN 1.0
END)
) AS "VALOR S"
或兩個過濾聚合
( SUM( (row_data->>'bankMovementAmount')::float ) FILTER (WHERE row_data->>'bankMovementOperationType' = 'E')
- SUM( (row_data->>'bankMovementAmount')::float ) FILTER (WHERE row_data->>'bankMovementOperationType' = 'S')
) AS "VALOR S"
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/497555.html
標籤：PostgreSQL jsonb