这是我的表结构。
我正在尝试编写一个CASE语句,如果'main_section=tender',则应返回投标金额;如果是银行,则应返回银行金额。如果有多条记录,则应将它们相加并返回总额(这里Tender有多条记录)。有人能帮我吗?以下是我尝试的CASE语句:
===================================
main_section | currency | amount
===================================
Tender INR 2000
Bank USD 3000
Tender INR 1500
Tender INR 1850
===================================
我正在尝试编写一个CASE语句,如果'main_section=tender',则应返回投标金额;如果是银行,则应返回银行金额。如果有多条记录,则应将它们相加并返回总额(这里Tender有多条记录)。有人能帮我吗?以下是我尝试的CASE语句:
CASE sum(com_payments.main_section
WHEN com_payments.main_section = 'Tender'
THEN main_tender = com_payments.amount
END AS maintender1)
CASE sum(com_payments.main_section
WHEN com_payments.main_section = 'Bank'
THEN main_bank = com_payments.amount
END AS mainbank1)
sum(case when main_section = 'Tender' then amount else 0 end) as maintender1,...............
如果你只有两个main_section
,为什么不使用select main_section,sum(amount) as amount group by main_section
呢? - Abhik Chakraborty