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 are the different stages involved in database testing?
What is white box testing and black box testing?
Define join and name different type of joins?
How to use sql queries in qtp?
How to test a sql query in winrunner? Without using database checkpoints?
You don’t have much time or only one day time, you have to execute 100 test cases, how you will execute
In database testing, how to do the data load testing?
What are joins?
How to test database in manually?
What is database testing and what we test in database testing?
How to test database in manually? Explain with an example?
What is the database trigger, how to verify the trigger is fired or not and can you invoke trigger on demand?