1. List all the departments of organization.
2. Display the name of departments headed by 5.
3. Display name of all the departments that are not in the forth floor
4. Accounts department is located in which floor.
5. Display name of department that is in second floor and headed by 1.
6. Display names of the employee in an organization along with date of birth and telephone number.
7. Display name of employee whose name start with ‘A’
8. Display details of employee that are not from the department 1,2 and 4.
9. Display details of employee Allen Smith.
10. Display details of employee having 'h' in second position and in last position in their first and last name
11. List details of employees that are from the department 2 and not located in Edinburg.
12. List details of employees born after 1961.
13. Display names of employee that are from Peebles, Biggar, Glasgow and Penicuik.
14. Display details of all employee having i as third character.
15. Display employee number, start date and enddate of all Accountant and Programmer.
16. Display details of positions held by employee 12.
17. Display employee number and salary of Assistant Admin Manager who joined after1975.
18. Display jobhistory of all Engineers.
19. Display jobhistory of System Analyst.
20. Display jobhistory of all employees having salary less than 15000.00
21. Display jobhistory of all the employees who joined after before 1980 and are engineers.
22. Display job history of all the employees who are currently working in an organization.
23. Display job history of employee who left the organization in the year 1980.
24. Display jobhistory of employees currently working as Junior Accountant.
25. Display details of employee who resign as accountant in year 1976.
26. Display details of employee worked between 1970 to 1980.
27. Display job history of employee whose salary is not greater than 10000 and not worked as electronic engineer.
28. Display total working days of all employee in any position.
29. Display job history of all programmers, Accountant and Trainee Engineer,
30. Display Employee Number, Designation and Net Salary of employee where Net Salary = Salary + DA – IT and DA is 12% of salary, IT is 12% of salary.
31. Display details of employee having salary 25000.00
No comments:
Post a Comment