var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Totals in two columns
Hello to all.
I'm new to sqlplus and i'm having difficulty in achieving the following:
I have a table with 3 columns:
Depending on the vat type i would like to have a query to return:
CUSTOMER_NAME, SUM(VAT_TYPE1), SUM(VAT_TYPE2)
Can someone please give some help of how to achieve this?
Thanks in advance for any kind help.
when vat_type = '1' then amount
end) as amount_vat_1,
when vat_type = '2' then amount
end) as amount_vat_2
GROUP BY customer_name
Totals in two columns
Shammat, thanks a ton.
You can use case statement to accomplish this....