in account table
account type amount
ac1 credit 300
ac2 debit 5000
ac3 credit 3000
ac1 debit 4000
ac3 debit 2000
ac2 credit 4000
write a query how to get sum of credit & sum of debit
Answer Posted / sanjay
select type,sum(amount)from account table group by type
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How are extents allocated to a segment?
What is the difference between a user and a schema in oracle?
What is a connect identifier?
What is a proxy class?
ABOUT IDENTITY?
What is a trigger and what are its types?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What is coalesce function?
What is not equal to in oracle?
How many file formats are supported to export data?
What is the usage of control file in oracle?
How to use values from other tables in update statements using oracle?
What is a snapshot in oracle database?
Is there a combination of "like" and "in" in sql?
Why is oracle database so popular?