[go: up one dir, main page]
Scribd
Upload
20 views3 pages

SQL EXPERIMENT NO.3

Uploaded by

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

SQL EXPERIMENT NO.3

Uploaded by

Karthik Nadar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

EXPERIMENT NO.

create table header15


(route_id int,
route_no int,
cat_code int,
origin varchar(20),
destination varchar(20),
fair decimal(7,2),
distance int,
capacity int);

select * from header15

insert into header15 values


(23,56,36,'aa','bb',78.90,9,10);

insert into header15 values


(12,24,28,'dd','hh',65.54,8,10);

insert into header15 values


(19,43,16,'cc','cd',56.12,6,12);

insert into header15 values


(36,72,41,'mm','ee',80.00,10,15);

insert into header15 values


(45,57,58,'ii','pp',90.87,15,15);
create table header21
(cat_code int primary key,
cat_desc varchar(20));

select * from header21

insert into header21 values (11,'aa');


insert into header21 values (51,'ee');
insert into header21 values (31,'dd');
insert into header21 values (54,'ds');
insert into header21 values (76,'gh');

create table header06


(place_id int,
place_name varchar(20),
bus_station varchar(20));
select * from header06

insert into header06 values(29,'sos','bo');


insert into header06 values(87,'pop','bs');
insert into header06 values(54,'dsf','cr');
insert into header06 values(91,'faf','bm');
insert into header06 values(77,'nop','mu');

create table header05


(student_id int,
student_name varchar(50),
student_add varchar(100));

select * from header05

insert into header05 values(99,'bib','abcd');


insert into header05 values(87,'mnm','mgkv');
insert into header05 values(58,'dgf','qkjs');
insert into header05 values(43,'ghf','wqxc');
insert into header05 values(30,'plp','mnbv');

You might also like