1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 / charykkr

Answers were Sorted based on User's Feedback



i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts wit..

Answer / sandeep

I hope this will be helpful.

SELECT sum(Account) as "Account Sum", sum(Amount) as "Amount
Sum", sum(Amount)-sum(Account) as "Difference" FROM account

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

Is oracle sql free?

0 Answers  

I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 Answers  

how to use regular expression in pattern match conditions? : Sql dba

0 Answers  

What are triggers in sql?

0 Answers  

what is the difference between char and varchar data types? : Sql dba

0 Answers  




what are the advantages of package?

7 Answers   iFlex,

How to copy a table in another table with datas?

9 Answers  

how to write date and time literals? : Sql dba

0 Answers  

Explain two easy sql optimizations.

0 Answers  

What type of database is sql?

0 Answers  

Can two tables have same primary key?

0 Answers  

Explain the components of sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories