SQl Tutorial and various Quiries

                    How to Create a table in SQL

General syntax for creating a Table is as follows

create table table_name(field1_name datatype(size), field2_name datatype(size),...........);

Eg,

CREATE TABLE SALESMAN

(SNUM NUMBER(4) PRIMARY KEY,

SNAME VARCHAR(20),

CITY VARCHAR(10),

COMMISSION NUMBER(6,2));

this query will create a table name SALESMAN