Question

Consider the following table stationary. Write SQL commands for following statement.

S_ID	S_Name	C_Name	Price	Quantity
001	Note Book	ABC	20	50
002	Pencil Box	XYZ	10	80
003	A4 Pages rim	PQR	600	2

Write SQL command to create above Table.

Answer 1

Create table Stationary (
S_ID int primary key,
S_Name varchar (20),
C_Name varchar (20),
Price smallint,
Quantity smallint
);