What is a database event trigger?
No Answer is Posted For this Question
Be the First to Post Answer
What is oracle and pl sql?
Query for second maximum salary in each in each department
15 Answers DST Global Solutions, TCS,
1. Which is an aggregate function? a. Union b. like c. max d. Rank
What are the types of join in sql?
What is case function?
Explain what is a field in a database and record in a database?
What is latest version of sql?
What is the use of primary key?
what are the security recommendations while using mysql? : Sql dba
What are sql queries used for?
What is difference between table and view?
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