SQL Question For Pratice--II

1.Display employee name and annual salary for all employees

2. Display the names of all employees working as clerks and drawing a salary more than

3000

3. Display names of employees who do not earn any commission

4. Display the names of employees who are working as clerk , salesman or analyst and drawing a salary more than 3000

5. Display the names of employees who are working in the company for the past 5 years

6. Display the list of employees who have joined the company before 30 th june 90 or after 31 st dec 90

7. Display the names of employees working in department number 10 or 20 or 40 or employees working as clerks , salesman or analyst

8. Display employee name from employees whose name ends with alphabet S

9. Display the names of employees whose name is exactly five characters in length

10. Display the names of employees who are not working as managers

11. Display the names of employees who are not working as SALESMAN or CLERK or

ANALYST?

12. Display the maximum salary being paid in dept no 20

13. Display the names of employees in order of salary i.e. the name of the employee earning lowest salary shoud appear first

14. .Display empnno,ename,deptno and sal. Sort the output first based on name and within name by deptno and witdhin deptno by sal;

15. Display the name of employees along with their annual salary(sal*12) the name of the employee earning highest annual salary should appear first?

16. Display  Department numbers and total number of employees working in each

Department?

17. Display the department Number with more than three employees in each department?

18. Display the employee Number and name for employee working as clerk  and earning highest salary among the clerks?

19. Display the names of employees who earn Highest salary in their respective departments?

20. Display the name of employee Concatinate with Employee Number?

21. Use appropriate function  and extract 3 characters starting from 2 characters from the following string 'Oracle' i.e., the out put should be ac?

22. Find the first occurance of character a from the following  string Computer

Maintenance Corporation?

23.  Replace every occurance of alphabet A with B in  the string .Alliens (Use Translate function)?

24.  Display the manager who is having maximum number  of employees  working under him?

25. Display avg sal figure for the dept