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-4 Table Creation Show structure Insertion of Records SELECT Query SELECT Query SELECT with ORDER BY SELECT Query SELECT Query SELECT Query SELECT Query SELECT with BETWEEN Nested Query SELECT with COUNT() SELECT with SUM() UPDATE Query SELECT with SUM, GROUP BY and ORDER BY


Show structure

Q:2
Show the structure of the STUDENT table.


SQL> DESC DEPOSIT;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ACCNO                                     NOT NULL NUMBER(8)
 NAME                                      NOT NULL CHAR(25)
 BRANCH                                             CHAR(20)
 AMOUNT                                    NOT NULL NUMBER(8,2)