- How to connect database with Core Java?
- How to find nth highest salary in SQL?
Following example use sub query to find out the nth highest salary from employee table:
SELECT salary FROM employee e1 WHERE (n-1) = ( SELECT COUNT(DISTINCT(e2.salary)) FROM employee e2 WHERE e2.salary > e1.salary; )
- What is the difference between truncate and delete?
- What is self join?
- What is the use of index in SQL?
- How many types of joins in SQL?
- What is group by clause?
- What is High water mark in Oracle?
- What is the difference between where and having clause?
- What are the differences between Primary key and Unique key?
- What is Self-Join?