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 is database testing and what we test in database testing?

492

Define join and name different type of joins?

566

What rdbms stands for and what are the important rdmbs that sql use?

541

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

559

What is the way of writing testcases for database testing?

507

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

445

What is difference between having clause and where clause?

563

What are indexes and mention different types of indexes?

512

How do you verify whether a database is updated when passing the data through front end?

516

How to verify the trigger is fired or not and can you invoke trigger on demand?

551

What are the steps to test data loading in database testing?

601

Mention different types of joins?

515

Does qtp support sql queries?

565

What is ddl and what are their commands?

522

What is the syntax to add record to a table?

536