How do you modify a table in sql?
how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What is trigger in sql and its types?
What is acid property in a database?
What is the difference between left outer join and left join?
What are the advantages of VIEW?
How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?
what is the functionality of the function htmlentities? : Sql dba
How many row comparison operators are used while working with a subquery?
Is there any restriction on the use of union in embedded sql?
i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.
Write the command to remove all players named sachin from the players table.