SQL Interview Questions

Are you getting ready for your SQL developer job interview?

You've come to the correct place.

This tutorial will assist you in brushing up on your SQL skills, regaining confidence, and being job-ready!

Here is a collection of real-world interview questions from organisations such as Google, Oracle, Amazon, and Microsoft, among others. Each question is accompanied by a neatly written answer inline, saving you time during interview preparation.

Following are some practise problems to help you master the fundamentals of SQL.

1. Find the third highest salary from the Employee table.

Note: We pass two parameters to the LIMIT clause, where the first one is the offset that is after which row data needs to be fetched and the second parameter is the row count that is how many rows it has to return. Here we need 1 row from after the 2nd row, hence LIMIT 2,1.

2. Display the first and last record from the Employee table.

For first record:

For last record:

Here subqueries has been used to get the minimum and maximum value of EMPID that is the first and last records and returned to the outer query respectively.

3. Display the list of employees working in the same department.

From the two tables E and E1 distinct employees are selected and returned the ones having the same department but different empID.

4. Retrieve the last 3 records from the Employee table.

Output of inner query is hold by the cursor temp then is returned to the outer query which rearranges the 3 records in ascending order.

5. Show details of employees whose EmpLastName ends with the alphabet ‘S’ and contains 4 alphabets.

Three underscore followed by s gives the last names ending with s and having total 4 letters.

6. Fetch the duplicate rows in a table.

Here the duplicates is found by calculating the count of each empID and returning the ones present more than once.

7. Calculate even and odd records from a table.

For Even:

For Odd:

MOD function is used for getting reminder, where the first parameter is the dividend and the second is divisor.

8. Write a query to retrieve first four characters of employee name.

Substring is a function that is used to get the parts of a string where the first parameter is the column name, followed by starting and ending positions respectively.

9. Write a query to return the number of employees whose DOB is between 01/01/1990 to 01/01/2001 and are grouped according to gender.

If we pass date in DD/MM/YYYY format then we need to specify it accordingly into the query:

10. Fetch the details of employees excluding the ones who are ‘HR’ and ‘ADMIN’.

Here the NOT IN operator has been used to filter the data from Department that is not having values as HR or Admin.

11. Display the total salary of each employee after adding 10% increment in the salary.

We perform the required arithmetic operations to get the desired result in a new column as New Salary.

12. Fetch the order details of today’s date. Given is the orders table with the order_id and their corresponding dates as order_Updated_date.

Date function is used to compare the order date and today’s date.

This blog gives you a rough pathway of core questions ans topics to follow. Ofcourse, you can and should explore more on your journe. Also, if you have any particular topic that you want covered, please write to us. If you wanna connect with me, here is my linkedin profile — Sneha Biswas. If you have any questions, feel free to contact me.