Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE nacar_ProductNorth(
- p_code NUMERIC (6,0) PRIMARY KEY NOT NULL,
- p_descript VARCHAR(25) NOT NULL,
- price NUMERIC (4,2) NOT NULL
- );
- INSERT INTO nacar_ProductNorth VALUES
- (123456, 'Flashlight', 5.26),
- (123457, 'Lamp', 25.15),
- (123458, 'Box Fan', 10.99),
- (213345, '9v battery', 1.92),
- (254467, '100W bulb', 1.47),
- (311452, 'Powerdrill', 34.99);
- CREATE TABLE nacar_ProductSouth(
- p_code NUMERIC (6,0) PRIMARY KEY NOT NULL,
- p_descript VARCHAR(25) NOT NULL,
- price NUMERIC (5,2) NOT NULL
- );
- INSERT INTO nacar_ProductSouth VALUES
- (345678, 'Microwave', 160.00),
- (345679, 'Dishwasher', 500.00),
- (123458, 'Box Fan', 10.99);
- SELECT * FROM nacar_ProductNorth
- UNION
- SELECT * FROM nacar_ProductSouth
- ORDER BY p_code ASC;
- UPDATE tablename
- SET toupdate = rightvalue
- WHERE toupdate = wrongvalue;
- SELECT * FROM nacar_ProductNorth
- INTERSECT
- SELECT * FROM nacar_ProductSouth
- ORDER BY p_code ASC;
- CREATE TABLE nacar_Sales2019_Quarter1(
- s_agent VARCHAR(10) NOT NULL,
- s_amount NUMERIC(8,2) NOT NULL
- );
- INSERT INTO nacar_Sales2019_Quarter1 VALUES
- ('Mike', 150000.25),
- ('Jon', 132000.75),
- ('Mary', 100000.00);
- CREATE TABLE nacar_Sales2019_Quarter2(
- s_agent VARCHAR(10) NOT NULL,
- s_amount NUMERIC(8,2) NOT NULL
- );
- INSERT INTO nacar_Sales2019_Quarter2 VALUES
- ('Mike', 120000.25),
- ('Jon', 142000.75),
- ('Mary', 100000.00);
- SELECT * FROM nacar_Sales2019_Quarter1
- UNION
- SELECT * FROM nacar_Sales2019_Quarter2
- ORDER BY s_agent ASC;
- SELECT * FROM nacar_Sales2019_Quarter1
- UNION ALL
- SELECT * FROM nacar_Sales2019_Quarter2
- ORDER BY s_agent ASC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement