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.

Answer Posted / priya

The question is not in proper grammar .. To me it looks like
what Biswaranjan interprets above

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we insert in view in sql?

570


Why are aggregate functions called so?

519


What is the difference between function and procedure in pl/sql?

546


What is cte?

577


How many developers work on postgresql?

568






Mention what does the hierarchical profiler does?

565


Can you have more than one key in a database?

509


How bulk collect improves performance?

574


what are the advantages of mysql in comparison to oracle? : Sql dba

532


What are database links used for?

595


Which is the correct statement about truncate and delete?

532


Explain the steps needed to create the scheduled job?

565


what is the difference between group by and order by in sql? : Sql dba

600


Can there be more than one function with a similar name in a pl/sql block?

551


What is the difference between microsoft sql and mysql?

513