SQL Questions

Here is a list of the most commonly used interview questions on SQL, covering both basics and advanced levels.

Questions
How to fetch the highest salary from an employee table?
How to fetch the 2nd highest salary from an employee table?
How to fetch the Nth highest salary from an employee table?
How to fetch the lowest salary from an employee table?
How to fetch the 2nd lowest salary from an employee table?
How to fetch the Nth lowest salary from an employee table?
How to fetch unique emails from a table?
How to fetch duplicate emails from a table?
How to fetch all Employees who are also Managers from the same table?
How to fetch only the first name from a full name column?
How to find the number of employees working in a specific department?
How to find the number of employees working in each department?
 

Related Links