Scribd
Upload
14 views1 page

SQL Table Creation and Queries

Uploaded by

shreyaseth2008
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
14 views1 page

SQL Table Creation and Queries

Uploaded by

shreyaseth2008
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

CREATE TABLE ITEM (

Item INTEGER PRIMARY KEY,

Item_name TEXT NOT NULL,

Price INTEGER NOT NULL,

Quantity INTEGER NOT NULL

);

INSERT INTO ITEM VALUES (11, 'Soap', 40, 62);

INSERT INTO ITEM VALUES (22, 'Powder', 80, 30);

INSERT INTO ITEM VALUES (33, 'Face Cream', 42, 25);

INSERT INTO ITEM VALUES (44, 'Shamppoo', 36, 100);

INSERT INTO ITEM VALUES (55, 'Soap Box', 15, 50);

INSERT INTO ITEM VALUES (66, 'washing Powder', 62, 25);

SELECT * FROM ITEM;

SELECT * FROM ITEM where price > 50

You might also like