If the application is running very slow? At what points you need to go about the database in order to improve the performance?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between union and union all command?
What is a recursive join sql?
what is hash join
Can you inner join the same table?
What is difference between select statement and cursor
What is pivot table in sql?
what is SCALAR Queries?
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
When the mutating error will comes? and how it will be resolved?
What is pivot in sql?
What are all the difference between Like and Contains ?
What is a mutating table