ME - 506 RDBMS Lab manual

RDBMS Lab Manual 

ME - 506

RDBMS lab Manual

Submitted by: Gautam Mangal

Contents  

S.no	Practical Name
1	Create the table EMPLOYEE  the description of the student are
2	Insert the record in the EMPLOYEE table
3	Select those tuples from the Employee where the  employee salary is greater than 10000 and less than 15000  .
4	Select  those tuples  from the Employee where the  employee name is start  from character A .
5	Retrieve the table in which the tuples are sorted in the increasing from of employee salary.
6	Apply the following  aggregate function in the employee salary column of employee table
7	Write the query to delete those tuples from the Employee where Employee city is London.
8	Write the query to Increase the employee salary by 5 percent in the Employee table where employee age is  25.
9	Write the query to add a new column  employee address  in the  Employee table where the type of new column is character and size is 25.
10	Write the query to delete  the table Employee

>> Click here to download <<