SELECT Name, Marks FROM Student s1 where 3 <= (SELECT COUNT(*) FROM Stud

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

Question Posted / krishna

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What does the rdbms stand for and what are the major rdbms used by sql?

552

What are indexes and mention different types of indexes?

558

What do you mean by index and explain different types of indexes?

624

What are the steps need to be taken while testing stored procedures?

481

What is performance testing and the bottlenecks of it?

499

What are dcl commands? What are the two types of commands used by dcl?

726

Does qtp support sql queries?

659

What is cmmi and describe different levels of cmm?

592

What do you mean by dcl commands and explain the types of commands used by dcl?

739

Mention different types of indexes?

609

What steps does a tester take in testing stored procedures?

571

How to test database procedures and triggers?

593

You don’t have much time or only one day time, you have to execute 100 test cases, how you will execute

790

What are the types of data-driven testing?

655

Why database testing is important?

579