SELECT SUM(C)-SUM(D) FROM TABLE

i have one table with accounts and amounts as
colums.accounts with columns c and d. and amounts with
values 1000,2000,3000 for c and 4000,5000,8000 for d.i need
to find the sum of these accounts c and d individually
and find the differences between their sum using one select
statement.

Question Posted / apurba

11 Answers
18752 Views
Ebix, Hewitt, I also Faced
E-Mail Answers

Answer Posted / apurba

SELECT SUM(C)-SUM(D) FROM TABLE_NAME;

Is This Answer Correct ?

8 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are predefined functions in sql?

1042

What are the uses of sysdate and user keywords?

1103

What is the difference between pl and sql?

1093

What is triggering circuit?

1064

What is set serveroutput on in pl sql?

1293

How much does sql certification cost?

1088

How do I turn a list into a table?

960

how to decrement dates by 1 in mysql? : Sql dba

1017

How to add new employee details in an employee_details table with the following details

1091

what is union, minus and interact commands? : Sql dba

1185

How to Execute a Package in PL/SQL.?

1202

Is sql workbench free?

992

Explain what is a field in a database and record in a database?

1097

How to create a menu in sqlplus or pl/sql?

1122

how can we destroy the cookie? : Sql dba

1011