SELECT Query

Q:9
Display the details of the students who scored more in Sub3 than any other subjects.


SQL>  SELECT ROLLNO, NAME, SUB1, SUB2, SUB3 FROM STUDENT WHERE SUB3 > SUB1 AND SUB3 > SUB2;

    ROLLNO NAME                            SUB1       SUB2       SUB3
---------- ------------------------- ---------- ---------- ----------
       103 AJAS                              60         70         80
       104 ROGER                             50         60         75
       105 BABU RAJ                          90         95         98
       106 SABU                              75         80         82