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
What are stored procedures in mysql?
What does := mean in pl sql?
What is benefit of creating memory optimized table?
What is cursor and its types?
What is Difference Between Unique and Primary Key Constraints?
how to get @@error and @@rowcount at the same time? : Sql dba
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What are the two types of cursors in pl sql?
Define overloaded procedure?
What is difference between sql function and stored procedure?
What is a dynamic query?
What is a nested table in word?
Can we use update in sql function?
Explain what is sql?
What do you think about pl/sql?