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 test database in manually?

563

After entering the data from the front-end application interface, how do you test whether a database is updated or not?

481

What are the different types of database testing?

619

What is difference between having clause and where clause?

587

What is white box testing and black box testing?

530

What is ddl and what are their commands?

540

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

508

What steps does a tester take in testing stored procedures?

538

How do you test whether a database in updated when information is entered in the front end?

531

How to test database procedures and triggers?

558

Mention different types of indexes?

537

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

756

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

692

Explain what is data driven test?

569

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

549