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 |
Without involving database checkpoints, how you can test a sql query in qtp?
What are joins?
How we can avoid duplicating records in a query?
What is the process of database testing?
What is performance testing and the bottlenecks of it?
What do you mean by white box testing and black box testing?
What do we usually check in database testing?
You don’t have much time or only one day time, you have to execute 100 test cases, how you will execute
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 we normally check for the database testing?
Suppose a student column has two columns, name and marks. How to get name and marks of top three students.
While testing stored procedures what are the steps does a tester takes?