Suppose a student column has two columns, name and marks. How to get name and marks of top three students.
Answer / krishna
SELECT Name, Marks FROM Student s1 where 3 <= (SELECT COUNT(*) FROM Students s2 WHERE s1.marks = s2.marks)
| Is This Answer Correct ? | 4 Yes | 0 No |
In data base testing, what are the steps to test data loading?
Without using database checkpoints, how you test a sql query in qtp?
What is the process of database testing?
What is white box testing and black box testing?
How to test database manually?
How to test a dts package created for data insert update and delete? What should be considered in the above case while testing it?
Explain what is data driven test?
How to test procedures and triggers of a database?
What is a trigger? How do you verify if a trigger is fired or not?
Explain how to use sql queries in qtp ?
In database testing, what all things are required for writing good test cases?
What is the database trigger?