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
19044 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 sap sql?

1030

how many columns can be used for creating index? : Sql dba

989

What is cursor explain with example?

1032

what's the difference between a primary key and a unique key? : Sql dba

1113

List the different type of joins?

1113

How do I save the results of sql query in a file?

1013

how to include comments in sql statements? : Sql dba

999

What is the difference between left and left outer join?

994

What is on delete set null?

1137

What is scope of pl sql developer in future?

1072

What is trigger in flip flop?

1063

how to select first 5 records from a table? : Sql dba

1029

How do I find duplicates in a single column in sql?

1070

What is nvarchar in sql?

978

What are the commands used in sql?

1136