vedaetl24@gmail.com   +91 9866978830
Menu

SQL

Home Interview Questions SQL

Interview Questions

  1. Get duplicate rows from the table:
  2. Remove duplicates in the table
  3. Rank query:
  4. Dense rank query
  5. Top 5 salaries by using rank
  6. Top Sal
  7. How to display alternative rows in a table?
  8. Hierarchical queries
  9. Greatest( ) function
  10. How to get maximum employees department details
  11. Which of the following queries will execute why ?
  12. How do you find the rows from 5th-10th from emp table ?
  13. How do you find last two rows from emp table ?
  14. How to delete the duplicate records form emp table W.r.t deptno and job ?
  15. How do you find the top 5 salaried employees from emp table ?
  16. Write the the query to display the maximum salaried employee details in each Department ? if two employees have same salaries and who joined first in the organization(hiredate) ?
  17. Write query to display the cumulative salary from emp table? also write the department wise cumulative salary ?
  18. Department wise cumulative salary
  19. write the query to display all the employees with average salary of department, count of employees in each department, sum of sal of department using analytical functions ?
  20. Department wise cumulative salary
  21. write the query to display all the employees with average salary of department, count of employees in each department, sum of sal of department using analytical functions ?
  22. Write query to display all the employees and their manager names?
  23. Write the query to display maximum and minimum salaried employee details in each department?
  24. How to display 5,10,15,20….records from emp table ?
  25. How to find whether a column has numeric date or character date ?
  26. Write the query to display the employees which have spaces either in the ename column or job column?
  27. write the query to find the ename, vowel count, consonant count from Emp table
  28. Display ename and last four characters in the ename from emp table if the ename from emp table if the ename has morethan 5 charecters
  29. When can we say two tables are identical w.r.t data? Write the query to check ?
  30. Consider the following two tables and write a query to find non-matching data in first table.