Simple Query

Q:4
Display a list of students having mark < 400.


SQL> SELECT * FROM STUDENT WHERE TOTAL < 400;

    ROLLNO NAME                      BRANCH                    TOTAL
---------- ------------------------- -------------------- ----------
       201 JOHN                      COMMERCE                    300
       202 BABU                      SCIENCE                     200
       205 VARGHESE                  SCIENCE                     250