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()


Table creation

Q:1
Create a table Student with fields
RollNo  Integer         Primary key
Name    Character (25)
Sub1    Number (4)
Sub2    Number (4)
Sub3    Number (4)
Total   Number (4)


SQL> CREATE TABLE STUDENT(
  2  ROLLNO INTEGER PRIMARY KEY,
  3  NAME CHARACTER(25),
  4  SUB1 NUMBER(4),
  5  SUB2 NUMBER(4),
  6  SUB3 NUMBER(4),
  7  TOTAL NUMBER(4));

Table created.