Suppose a student column has two columns, name and marks. How to get name and ma

Suppose a student column has two columns, name and marks. How to get name and marks of top three students.

Question Posted / vikas agarwal

Suppose a student column has two columns, name and marks. How to get name and marks of top three stu..

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

More Database Testing Interview Questions

What is cmmi and describe different levels of cmm?

How to check a trigger is fired or not, while doing database testing?

How to test procedures and triggers of a database?

While testing stored procedures what are the steps does a tester takes?

What is the way of writing testcases for database testing?

What is database testing and what we test in database testing?

How to test database procedures and triggers?

In database testing, what do we need to check normally?

Explain database testing?

Without using database checkpoints, how you test a sql query in qtp?

What do we usually check in database testing?

Mention different types of joins?

For more Database Testing Interview Questions Click Here