Saturday, September 17, 2011
Thursday, September 15, 2011
Sunday, September 11, 2011
(3rd IT)Experiment No 7,8,9,10
Experiment No. 7
Q-1> Retrieve emp name and job who have the same job as that of allen?
Q-2> List all emp name and their job of those depts. That are located at Chicago?
Q-3> List all emp name and sal whose sal is greater then that of all managers?
Q-4>display all emp names and sal where sal is less then that of any manager of any dept?
Q-5> List all emp name, dept names and location whose deptno is common in both dept table and emp table?
Q-6> List all jobs in dept 10 and 20 or in both?
Q-7> List all jobs which are common in dept 10 and 20 ?
Q-8> List all jobs which are present in dept 10 but not in dep 20?
Experiment No. 8
Q-1> Display emp name as job and working form hiredate?
In the following format:
SMITH is CLERK and working from17-DEC-80
Q-2> To get all the employees whose salary is greater than the average salary of the company.
Q-3> To select all the employees who do the same job as that of Scott.
Q-4> To see all details of depts. Who have employees working in it.
Q-5> To find names and salary details of all employees whose salary is equal to the salary given to an employee working in dept no. 30
Q-6> To select the employees whose salary is greater than the salary of all employees working in dept no. 30
Q-7> To list all details of dept which has at least one employ assigned to it.
Experiment No. 9
Q-1> Create unique index on job on the emp table.
Q-2> Remove the index created for the emp table.
Q-3> Create view on emp displaying deptno , dept name , sal , job.
Q-4> Drop the above view.
Q-5> Create view on emp displaying ename , job ,sal in dept 10.
Q-6> Drop the above view.
Q-7> Create view on emp to display sum of salary grouped according to deptno?
Q-8> Drop the above view?
Q-9> Create view on appropriate tables to display ename , job , sal , dept name?
Q-10> Drop the above view?
Experiment No. 10
Q-1> To find out average minimum and maximum salary of each dept.
Q-2> To find out average maximum and minimum salary of departments where average salary is greater than 2000.
Q-3> To list the minimum salary to various categories of employees.
Q-4> To find the minimum salaries of various categories of employees in various depts.
Q-5> To find the minimum salaries of various categories of employees, department wise such that minimum salary is greater than 1500.
Q-6> To find the minimum salary of managers in various depts.
Q-7> To find the minimum salary of managers in various depts. Having salary greater than 2500.
Q-8> To list all employees in the ascending order by name.
Q-9> To select all employees sorted dept wise in ascending order and within dept salary wise in descending order.
Q-10> To select all employees sorted dept wise in ascending order and within dept salary wise in descending order for dept no. 10 and 20.
Q-11> To select all employees along with their annual salary sorted on the basis of annual salary.
Q-1> Retrieve emp name and job who have the same job as that of allen?
Q-2> List all emp name and their job of those depts. That are located at Chicago?
Q-3> List all emp name and sal whose sal is greater then that of all managers?
Q-4>display all emp names and sal where sal is less then that of any manager of any dept?
Q-5> List all emp name, dept names and location whose deptno is common in both dept table and emp table?
Q-6> List all jobs in dept 10 and 20 or in both?
Q-7> List all jobs which are common in dept 10 and 20 ?
Q-8> List all jobs which are present in dept 10 but not in dep 20?
Experiment No. 8
Q-1> Display emp name as job and working form hiredate?
In the following format:
SMITH is CLERK and working from17-DEC-80
Q-2> To get all the employees whose salary is greater than the average salary of the company.
Q-3> To select all the employees who do the same job as that of Scott.
Q-4> To see all details of depts. Who have employees working in it.
Q-5> To find names and salary details of all employees whose salary is equal to the salary given to an employee working in dept no. 30
Q-6> To select the employees whose salary is greater than the salary of all employees working in dept no. 30
Q-7> To list all details of dept which has at least one employ assigned to it.
Experiment No. 9
Q-1> Create unique index on job on the emp table.
Q-2> Remove the index created for the emp table.
Q-3> Create view on emp displaying deptno , dept name , sal , job.
Q-4> Drop the above view.
Q-5> Create view on emp displaying ename , job ,sal in dept 10.
Q-6> Drop the above view.
Q-7> Create view on emp to display sum of salary grouped according to deptno?
Q-8> Drop the above view?
Q-9> Create view on appropriate tables to display ename , job , sal , dept name?
Q-10> Drop the above view?
Experiment No. 10
Q-1> To find out average minimum and maximum salary of each dept.
Q-2> To find out average maximum and minimum salary of departments where average salary is greater than 2000.
Q-3> To list the minimum salary to various categories of employees.
Q-4> To find the minimum salaries of various categories of employees in various depts.
Q-5> To find the minimum salaries of various categories of employees, department wise such that minimum salary is greater than 1500.
Q-6> To find the minimum salary of managers in various depts.
Q-7> To find the minimum salary of managers in various depts. Having salary greater than 2500.
Q-8> To list all employees in the ascending order by name.
Q-9> To select all employees sorted dept wise in ascending order and within dept salary wise in descending order.
Q-10> To select all employees sorted dept wise in ascending order and within dept salary wise in descending order for dept no. 10 and 20.
Q-11> To select all employees along with their annual salary sorted on the basis of annual salary.
Thursday, September 8, 2011
Sunday, September 4, 2011
Eperiment No. 5 & 6 ( 3rd sem IT)
Experiment No. 5
Q-1> To find the total number of employees.
Q-2> To find the total number of clerk hired after 13-jan-81.
Q-3> To find the sum paid as salary to all employees every month.
Q-4> To find the yearly compensation paid to all sales men.
Q-5> To find the average salary of all the employees.
Q-6> To find the average yearly compensation paid to sales men.
Q-7> To find the minimum salary paid to any employee
Q-8> To list the employee who heads the list alphabetically.
Q-9> To find the maximum salary paid to any employee.
Q-10> Convert the hiredate format of employee in dd/ mm/ yyyy format ?
Q-11> Find the date after 4 month as per today ?
Q-12> Find out the last day of the current month ?
Q-13> Display the last working day of all employees on their joining month ?
Experiment No. 6
Q-1> To find out average minimum and maximum salary of each dept.
Q-2> To find out average maximum and minimum salary of departments where average salary is greater than 2000.
Q-3> To list the minimum salary to various categories of employees.
Q-4> To find the minimum salaries of various categories of employees in various depts.
Q-5> To find the minimum salaries of various categories of employees, department wise such that minimum salary is greater than 1500.
Q-6> To find the minimum salary of managers in various depts.
Q-7> To find the minimum salary of managers in various depts. Having salary greater than 2500.
Q-8> To list all employees in the ascending order by name.
Q-9> To select all employees sorted dept wise in ascending order and within dept salary wise in descending order.
Q-10> To select all employees sorted dept wise in ascending order and within dept salary wise in descending order for dept no. 10 and 20.
Q-11> To select all employees along with their annual salary sorted on the basis of annual salary.
Q-1> To find the total number of employees.
Q-2> To find the total number of clerk hired after 13-jan-81.
Q-3> To find the sum paid as salary to all employees every month.
Q-4> To find the yearly compensation paid to all sales men.
Q-5> To find the average salary of all the employees.
Q-6> To find the average yearly compensation paid to sales men.
Q-7> To find the minimum salary paid to any employee
Q-8> To list the employee who heads the list alphabetically.
Q-9> To find the maximum salary paid to any employee.
Q-10> Convert the hiredate format of employee in dd/ mm/ yyyy format ?
Q-11> Find the date after 4 month as per today ?
Q-12> Find out the last day of the current month ?
Q-13> Display the last working day of all employees on their joining month ?
Experiment No. 6
Q-1> To find out average minimum and maximum salary of each dept.
Q-2> To find out average maximum and minimum salary of departments where average salary is greater than 2000.
Q-3> To list the minimum salary to various categories of employees.
Q-4> To find the minimum salaries of various categories of employees in various depts.
Q-5> To find the minimum salaries of various categories of employees, department wise such that minimum salary is greater than 1500.
Q-6> To find the minimum salary of managers in various depts.
Q-7> To find the minimum salary of managers in various depts. Having salary greater than 2500.
Q-8> To list all employees in the ascending order by name.
Q-9> To select all employees sorted dept wise in ascending order and within dept salary wise in descending order.
Q-10> To select all employees sorted dept wise in ascending order and within dept salary wise in descending order for dept no. 10 and 20.
Q-11> To select all employees along with their annual salary sorted on the basis of annual salary.
Subscribe to:
Posts (Atom)