Name : Ayush Semwal
University Roll. No. : 2321262
Course : BCA
Section : B1
Roll. No. : 18
Subject : DBMS Lab
Submitted To : Mrs. Neha Bhatt Ma’am
PRACTICAL - 08
1. List the details of employee who have 4 lettered Name.
2. Display the name of the employee whose name has 't' as the last
alphabet.
3. List the detail of Employee who don't have any manager.
34
Name : Ayush Semwal
University Roll. No. : 2321262
Course : BCA
Section : B1
Roll. No. : 18
Subject : DBMS Lab
Submitted To : Mrs. Neha Bhatt Ma’am
4. List the name of all the employee whose name has 'M' as first
alphabet & 'l' as the 3rd alphabet.
5. List the Details of all employee whose salary lies between 1000 &
10000.
6. List the detail of employee who are salesman or analyst or manager.
35
Name : Ayush Semwal
University Roll. No. : 2321262
Course : BCA
Section : B1
Roll. No. : 18
Subject : DBMS Lab
Submitted To : Mrs. Neha Bhatt Ma’am
7. Display the details of employee '7900' in the format "e_name is a
'job'" (use CONCAT) .
8. Create a query to display the following format "e-name earns $
salary monthly and working as 'job' " in employee table.
36
Name : Ayush Semwal
University Roll. No. : 2321262
Course : BCA
Section : B1
Roll. No. : 18
Subject : DBMS Lab
Submitted To : Mrs. Neha Bhatt Ma’am
9. Concat e-name & emp-no having emp-no '7900' & '7788'.
10. Create a view table 'v1' and load the data of all employee whose
job is manager and salesman. Display the data of view table.
37
