Experiment No. 11
Q-1> Creat the following table and insert the given value.
Employees:
Emp_id Name
01 Hansen,Ola
02 Svendson, Tova
03 Svendson, Stephen
04 Pettersen, Kari
Orders:
Prod_id Product Emp_id
234 Printer 01
657 Table 03
865 Chair 03
Q-2> Who ordered a product and what did they order.
Q-3> Who ordered a printer.
Q-4> List all the employees and their order if any.
Q-5> List all orders and who has ordered if any.
Subscribe to:
Post Comments (Atom)
-
Practical exam Q No. 1 Q-1> Write a query in sql to create a table employee and department. Employee(empno,ename,deptno,job,hiredate...
-
4.2 Decomposition Techniques As mentioned earlier, one of the fundamental steps that we need to undertake to solve a problem in parallel... -
Answers Experiment No. 1 1. SQL> create table deptit(deptno number(2) primary key,dname varchar(14) not null,loc varchar(13) not null); T...
No comments:
Post a Comment