Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/lsp4you/public_html/connect.php on line 2 LSP4YOU - Learner's Support Publications
SQL Lab Exercises-2 Table creation Show Structure Record Insertion Update Query SELECT with MAX() SELECT with ORDER BY SELECT with MAX() Nested Query SELECT Query SELECT with AVG()


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