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 |
What do you mean by dml?
What we normally check for the database testing?
How do you verify whether a database is updated when passing the data through front end?
What is the database trigger?
How to test a dts package created for data insert update and delete? What should be considered in the above case while testing it?
What is retesting & how it is different from data driven testing?
What are joins?
What is the way of writing testcases for database testing?
What are the challenges you faced while performing database testing?
What are joins and mention different types of joins?
How to test database procedures and triggers?
How to test a dts package created for data insert update and delete?