STUDENT Student ID Read Student ID Read 3000 23 3001 56 3002

STUDENT (Student ID, Read) Student ID Read 3000 2.3 3001 5.6 3002 1.3 3003 3.3 3004 2.7 3005 4.8 3006 7.8 3007 1.5 Which student has the highest read score? Write SQL Query for this in SQL MANAGEMENT SERVER 2014

Solution

SQL Query:-

SELECT * FROM STUDENT S1

WHERE N-1 =

(SELECT COUNT (Read) FROM STUDENT S2 WHERE S2.Read > S1.Read);

Student has the highest read score denotes first highest read score. N = 1.

Semi-Final Query:-

SELECT * FROM STUDENT S1

WHERE 1-1 =

(SELECT COUNT (Read) FROM STUDENT S2 WHERE S2.Read > S1.Read);

Final Query:-

SELECT * FROM STUDENT S1

WHERE 0 =

(SELECT COUNT (Read) FROM STUDENT S2 WHERE S2.Read > S1.Read);