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-3 Table creation Show table structure Record Insertion Simple Query SELECT with COUNT() SELECT with MIN() and MAX() Simple Query SELECT with MAX() SELECT with ORDER BY .. DESC SELECT with BETWEEN SELECT with COUNT() Show all records UPDATE Query SELECT USING COUNT() with GROUP BY COUNT() with GROUP BY and ORDER BY


Show all records

Q:12
Show all the records from the table.


SQL> SELECT * FROM STUDENT;

    ROLLNO NAME                      BRANCH                    TOTAL
---------- ------------------------- -------------------- ----------
       201 JOHN                      COMMERCE                    300
       202 BABU                      SCIENCE                     200
       203 GEORGE                    HUMANITIES                  500
       204 JIBIN                     COMMERCE                    400
       205 VARGHESE                  SCIENCE                     250
       206 SOMAN                     HUMANITIES                  420

6 rows selected.