Scribd
Upload
2 views2 pages

SQL Interview Questions

The document contains a list of SQL interview questions aimed at assessing knowledge and skills in SQL through practical scenarios. Each question is followed by a corresponding SQL query solution, covering topics such as salary calculations, employee management, and data manipulation. The questions are designed to enhance understanding of SQL and prepare candidates for real-world applications.

Uploaded by

MATHS the MAGIC
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views2 pages

SQL Interview Questions

The document contains a list of SQL interview questions aimed at assessing knowledge and skills in SQL through practical scenarios. Each question is followed by a corresponding SQL query solution, covering topics such as salary calculations, employee management, and data manipulation. The questions are designed to enhance understanding of SQL and prepare candidates for real-world applications.

Uploaded by

MATHS the MAGIC
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

SQL Interview Questions

1. How can you find the second-lowest salary in a table without using MIN?

2. Write a query to find employees who report to the same manager and have the exact same salary.

3. Identify rows where a specific column has missing or null values and replace them with the column’s
average.

4. Write a query to find the employees whose salaries rank in the top 5% without using percentile
functions.

5. Calculate a running total of sales in a table.

6. Find employees who have worked in more than one department.

7. Write a query to compare each employee’s salary with the average salary of their department.

8. Identify departments that currently have no employees.

9. Write a query to display the total sales for each month in a pivot-like format.

10. Determine employees whose salaries increased by more than 20% compared to their last salary.

These questions are designed to enhance your understanding of SQL and help you tackle real-world
scenarios effectively.

Answers:

Here are the solutions to these questions:

1. Find the second-lowest salary without MIN

SELECT salary FROM employees


WHERE salary > (SELECT DISTINCT salary FROM employees ORDER BY salary ASC LIMIT 1)
ORDER BY salary ASC LIMIT 1;

2. Employees with the same salary under the same manager

SELECT e1.* FROM employees e1


JOIN employees e2 ON e1.manager_id = e2.manager_id
WHERE [Link] = [Link] AND e1.employee_id <> e2.employee_id;

3. Replace NULLs with the column’s average

UPDATE table_name
SET column_name = (SELECT AVG(column_name) FROM table_name WHERE column_name IS NOT
NULL)

[Link]
WHERE column_name IS NULL;

4. Top 5% salaries without percentile functions

SELECT * FROM employees


WHERE salary >= (SELECT salary FROM employees ORDER BY salary DESC LIMIT (SELECT
COUNT(*) FROM employees) * 5 / 100);

5. Calculate running total of sales

SELECT id, sales, SUM(sales) OVER (ORDER BY id) AS running_total


FROM sales_table;

6. Employees in multiple departments

SELECT employee_id FROM employee_department


GROUP BY employee_id
HAVING COUNT(DISTINCT department_id) > 1;

7. Compare salary with department average

SELECT employee_id, salary,


AVG(salary) OVER (PARTITION BY department_id) AS avg_dept_salary
FROM employees;

8. Departments with no employees

SELECT department_id FROM departments


WHERE department_id NOT IN (SELECT DISTINCT department_id FROM employees);

9. Pivot-like format for total sales

SELECT
SUM(CASE WHEN month = 'January' THEN sales END) AS January,
SUM(CASE WHEN month = 'February' THEN sales END) AS February,
SUM(CASE WHEN month = 'March' THEN sales END) AS March
FROM sales_table;

10. Employees with >20% salary increase

SELECT e.employee_id FROM employees e


JOIN salary_history s ON e.employee_id = s.employee_id
WHERE [Link] > 1.2 * s.previous_salary;

[Link]

You might also like