Java Scrap Book  

Java Scrap Book > Database Interview Question

Database Interview Question

  1. What is difference between inner and outer join in SQL.
  2. What is difference between left outer join and right outer join in SQL.
  3. Find nth highest salary
  4. What is difference between primary key and foreign Key
  5. What is difference between having and where clause
  6. What is self join
  7. Example for distinct and order by together