Category Archives: SQL Queries

sql query interview questions

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 »

Find nth highest salary SQL query

Preparing for an interview and have very less time left to cover all the topics. Don’t worry here we are giving you a collection of interview questions, which we have chosen after doing a very thorough research with hundreds of candidates .First thing is in most of the interviews you will encounter the SQL query… Read More »