SELECT SUM(C),SUM(D),SUM(C)-SUM(D) 'difference' FROM accounts;

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 / akki julak

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

Answer Posted / akki julak

SELECT SUM(C),SUM(D),SUM(C)-SUM(D) 'difference'
FROM accounts;

Is This Answer Correct ?

3 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to create your own reports in sql developer?

976

Is vs as in pl sql?

935

Is delete faster than truncate?

960

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7140

What are the different ways to optimize a sql query?

891

what are the differences between binary and varbinary? : Sql dba

978

what are the advantages and disadvantages of views in a database? : Sql dba

997

How can we store rows in PL/SQL using array?

1162

What is partition by in sql?

1002

What are system versioned tables?

969

What is foreign key in sql with example?

892

what is a unique key ? : Sql dba

1029

How do I view tables in mysql?

917

What is cursor explain with example?

924

define data blocks ? : Sql dba

932