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
19046 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 is csv? : Sql dba

1051

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1164

What is a table partition?

1208

What are predefined functions in sql?

1109

What are the types of variable use in pl sql?

1138

What is integrity in sql?

1107

What are three advantages to using sql?

1072

How do you concatenate in sql?

1086

What does varchar include?

995

how to create a new table in mysql? : Sql dba

1035

what is innodb? : Sql dba

1172

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4464

how to concatenate two character strings? : Sql dba

1161

What are the disadvantages of not performing database normalization?

1217

what is normalization? : Sql dba

1137