What is materialized view in sql?
No Answer is Posted For this Question
Be the First to Post Answer
when a procedure /package is getting invalidated?
What is composite primary key in sql?
What is the difference between unique and primary key constraints?
What are different types of functions in sql?
What are the different schemas objects that can be created using pl/sql?
Explain exception handling in pl/sql?
function can return value ,procedure also return value through out parameter then what is the difference?
What is the purpose of normalization?
What is a temp table?
Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy
What is the maximum database size for sql express?
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.