Register
Suppose a student table has two columns, names and marks. How to get name and marks of top three students
190k views
1 vote
Suppose a student table has two columns, names and marks. How to get name and marks of top three students

User Tim Strijdhorst
by
4.1k points

1 Answer

1 vote

Answer:

SELECT Name, Marks FROM Student s1 where 3 <= (SELECT COUNT(*) FROM Students s2 WHERE s1.marks = s2.marks)

User Liz Barrett
by
5.2k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

4.4m questions

5.7m answers

Other Questions

Evan is building a toy rocket. He wants to fill the rocket with high-pressure water in order to launch it into the air. Which of the following materials would be the best choice for constructing the outside
Which of the following questions would an immunologist be most interested in? How does lung cancer spread to other organs? How long does it take for bones to repair themselves after breaks? What is the
Implement this C program by defining a structure for each payment. The structure should have at least three members for the interest, principle and balance separately. And store all the payments in a structure
Solving for dominant strategies and the Nash equilibrium Suppose Andrew and Beth are playing a game in which both must simultaneously choose the action Left or Right. The payoff matrix that follows shows
The steady-state data listed below are claimed for a power cycle operating between hot and cold reservoirs at 1200 K and 400 K, respectively. For each case, evaluate the net power developed by the cycle,
Link Copied!