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

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

633


what is a database lock ? : Sql dba

589


What is the difference between partition and index?

482


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

529


Can we use delete in merge statement?

512






What does partition by mean in sql?

513


Can we use ddl commands in pl sql?

554


What is difference between sql and oracle?

560


What has stored procedures in sql and how we can use it?

563


What do you mean by table in sql?

524


What is the use of double ampersand (&&) in sql queries? Give an example

609


What is graph sql?

524


What types of commands can be executed in sql*plus?

550


Can you do multiple joins in sql?

543


What are sql functions? Describe the different types of sql functions?

555