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
18775 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

how to delete an existing column in a table? : Sql dba

1010

How many clustered indexes can be created on a table?

1081

What are the packages in pl sql?

1017

Is sql a programming?

980

What does the acronym acid stand for in database management?

1034

What is the use of & in pl sql?

1049

How are functions and procedures called in PL/SQL?

1240

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

977

What is an exception in PL/SQL? What are the two types of exceptions?

1316

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1072

How many types of sql are there?

991

What is the sql*loader? : aql loader

1058

Is sqlite good enough for production?

998

Why is partition used in sql?

1130

What is the difference between execution of triggers and stored procedures?

1120