1. How to connect database with Core Java?
  2. 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;
  3. What is the difference between truncate and delete?
  4. What is self join?
  5. What is the use of index in SQL?
  6. How many types of joins in SQL?
  7. What is group by clause?
  8. What is High water mark in Oracle?
  9. What is the difference between where and having clause?
  10. What are the differences between Primary key and Unique key?
  11. What is Self-Join?
LinkedIn Auto Publish Powered By :