Tag Archives: sql

Explain different types of SQL JOINs

SQL JOINs is among the most frequently asked interview questions in database interviews.I’m assuming you already know what joins are but don’t know the difference between various types of JOINs. Here I’ve tried to briefly explain all the SQL Joins.For a more detailed explanation you can use refer this link SQL JOINs What are the… Read More »

SQL queries :set 2

Given 2 tables Country and City as shown below: Country (countryid, countryname ) City (countryid, cityname ) 1. Write a SQL query to find the countries that has no cities? This can be easily solve using left outer join

2. Write a SQL query to find the countries that has less than 5 cities… Read More »