Consider a relation Report (RollNo, Marks) that keeps record of total marks obtained by the students having distinct roll number in class X. Assume the following query-
SELECT R1.RollNo. FROM REPORT R1 WHERE (SELECT COUNT(DISTINCT R2.Marks) FROM REPORT R2 WHERE R1.Marks < R2.Marks) <= 3;
Which of the following statements is/ are not equivalent to the above SQL Query?
1
Retrieve roll numbers who are top scores of top 3 highest marks in the class
2
Retrieve roll number who secured 3rd highest marks in the class
3
Retrieve roll number wo are scores of top 4 highest marks in the class
4
Retrieve roll number who secured 4th highest marks in the class.