Frequently asked SQL Interview Questions on EMP, DEPT table

SQL EMP DEPT_Logo_www.OracleAppsDNA.com

Click on the question to see the answer

  1. How to display 9th record from EMP table?
  2. HOW TO DISPLAY 5 TO 7 ROWS FROM A TABLE?
  3. Write a Query to Delete The Repeated Rows from emp table?
  4. How to Delete the rows of employees who are working in the company for more ?
  5. How to impose a validation saying that salary cannot be greater 10,000 (note give a name to this constraint)
  6. How to display those employee whose joining DATE is available in deptno?
  7. How to display those employee whose joining of month and grade is equal?
  8. How to display all enames in reverse order? (SMITH:HTIMS)
  9. How to display the 10th record of emp table(without using rowid) ?
  10. How to display those employees who joined the company before 15 of the month?
  11. How to display employee name and his salary whose salary is greater than highest average of department number?
  12. How to display those employee whose 10% of salary is equal to the year of joining?
  13. How to display those employee who joined in the company in the month of Dec?
  14. How to display those employee whose salary is ODD value?
  15. How to find out last 5 (least) earners of the company.?
  16. How to display employee name, sal, comm and net pay for those employee whose net pay is greater than or equal to any other employee salary of the company?
  17. How to display those managers name whose salary is more than average salary of his employee?
  18. How to display dname where at least 3 are working and display only department name?
  19. How to find out the top 5 earners of company based on emp dept table?
  20. How to display all employees name,job,salary,grade and depart name for every one in the company except ‘CLERK’.Sort on salary display the highest salary?
  21. How to display grade and employees name for the dept no 10 or 30 but grade is not 4 while joined the company before 31-dec-82?
  22. How to display those employees who are working in the same dept where his manager is work?
  23. How to display employee name, dept name, salary and comm for those sal in between 2000 to 5000 while location is Chicago?
  24. How to display the Job groups having total salary greater than the maximum salary for managers?
  25. How to display the names of the employees who earn highest salary in their respective departments?
  26. How to display the names of clerks who earn a salary more than the lowest salary of any salesman?
  27. How to display the employee number and name for employee working as clerk and earning highest salary among clerks?
  28. How to display name,salary,hra,pf,da,total salary for each employee. The output should be in the order of total salary,hra 15% of salary,da 10% of salary,pf 5% salary,total salary will be(salary+hra+da)-pf?
  29. How to display the names of employees whose names have second alphabet A in their names?
  30. How to display the names of the employees who are working in the company for the past 5 years?
  31. How to display the names of all the employees who are working as clerks and drawing a salary more than 3000?
  32. How to display the employee name and annual salary for all employees including commission?

Note: New Questions will be added to this list on regular basis