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

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

488

Mention different types of joins?

464

How to test a dts package created for data insert update and delete?

404

What is the process of database testing?

505

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

610

What is the way of writing testcases for database testing?

454

Explain database testing?

476

In database testing, what all things are required for writing good test cases?

468

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

467

How to test database in manually?

464

What is cmmi and describe different levels of cmm?

494

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

503

What we normally check for the database testing?

393

What is difference between having clause and where clause?

514

Mention different types of indexes?

450