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

What is the use of pl/sql table?

1067

What is rank dense_rank and partition in sql?

1042

Is stored procedure faster than query?

969

What is sql and also describe types of sql statements?

1066

What is rownum in sql?

1043

Explain unique key in sql.

1014

Is sqlexception checked or unchecked?

968

How to return multiple rows from the stored procedure?

970

What is a delimiter in sas?

1058

Why truncate is faster than delete?

1114

What is form and report?

989

How do I order columns in sql?

1007

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1004

What is the difference between delete and truncate statement in sql?

1070

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

1111