Scribd
Upload
42 views2 pages

Data Base Lab 4

The document outlines a database lab exercise involving the creation and manipulation of two tables: 'orders' and 'PERSONS'. It includes SQL commands for inserting data, selecting data with various join operations, and querying specific information based on conditions. Additionally, it demonstrates the use of outer joins and filtering on hire dates in employee records.

Uploaded by

rowen prather
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
42 views2 pages

Data Base Lab 4

The document outlines a database lab exercise involving the creation and manipulation of two tables: 'orders' and 'PERSONS'. It includes SQL commands for inserting data, selecting data with various join operations, and querying specific information based on conditions. Additionally, it demonstrates the use of outer joins and filtering on hire dates in employee records.

Uploaded by

rowen prather
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

Data base lab 4

1. Create table orders (O_Id int primary key, Orderno int, P_Id int);
2. insert all
a. into orders(O_Id int primary key, Orderno int, P_Id int)values ( 1, 77895, 3)
b. into orders(O_Id int primary key, Orderno int, P_Id int)values ( 2, 44678 ,3)
c. into orders(O_Id int primary key, Orderno int, P_Id int)values ( 3 ,22456 ,1)
d. into orders(O_Id int primary key, Orderno int, P_Id int)values ( 4 ,24562, 1)
e. into orders(O_Id int primary key, Orderno int, P_Id int)values ( 5, 34764, 15)
select * from orders;
3. create table PERSONS (p_Id int, Lastname varchar(10), Firstname varchar(10), Address
varchar(20),city varchar(10));
4. inset all
a. into PERSONS (p_Id int, Lastname varchar(10), Firstname varchar(10), Address
varchar(20),city varchar(10)) values ( 1 ,Hansen ,Ola, Timoteivn 10, Sandnes)
b. into PERSONS (p_Id int, Lastname varchar(10), Firstname varchar(10), Address
varchar(20),city varchar(10)) values ( 2 ,Svendson ,Tove, Borgn 23, Sandnes)
c. into PERSONS (p_Id int, Lastname varchar(10), Firstname varchar(10), Address
varchar(20),city varchar(10)) values ( 3 ,Pettersen ,Kari ,Storgt 20, Stavanger)
d. select * from persons
5. select column_name(s) from table1 left join table2 on
table1.column_name=table2.column_name;
6. select [Link], [Link], orders.o_id
from persons
fulll outer join orders
on persons.p_id = orders.p_id
7. select [Link], [Link], orders.o_id
from persons
fulll outer join orders
on persons.p_id = orders.p_id
order by [Link];
8. select orders.o_id, [Link], [Link]
from orders
right outer join persons
on orders.p_id = persons.p_id;
9. select orders.o_id, [Link], [Link]
from orders
right outer join persons
n orders.p_id = persons.p_id
order by [Link] desc;
10. Select ename, dname from employee E, dept D where [Link] -= [Link];
11. Select [Link], [Link], [Link], [Link] from employee E, dept D where
[Link]=[Link]
12. Select [Link], [Link],[Link] from emp E, salgrade S Where [Link] between [Link] and
[Link]
13. Select [Link] as ‘employee’, [Link] as ‘empno’, [Link] as ‘mgrno’,
[Link] as ‘manager’ from emp left outer join emp M . N [Link]= [Link];
14. Select ename from emo where mgr=’null’;
15. Select ename, hiredate from emp where (year(hiredate) = ‘1981%’ and month(hiredate) =
‘feb%’);

You might also like