SQL Interviews

SQL Interviews

SQL interview questions covering queries, joins, indexing, optimization, and database concepts.

41 Topics Beginner to Advanced 4+ Hours

1

2

What are the different types of SQL statements?

3

What is the difference between DELETE, TRUNCATE, and DR

4

What is a primary key?

5

What is a foreign key?

6

What are the different types of joins in SQL?

7

What is the difference between WHERE and HAVING?

8

What is the use of the GROUP BY clause?

9

What is the difference between UNION and UNION ALL?

10

What is an index in SQL?

11

What types of index in SQL?

12

What is a subquery?

13

How do you use the BETWEEN operator?

14

How can you find the second highest salary from a table

15

Explain the use of CASE statements in SQL.

16

What is a view?

17

What are the limitations of SQL?

18

Write a query to fetch all records from a table named employees.

19

Write a query to fetch unique department names from the departments table.

20

Write a query to count the number of rows in the orders table.

21

Write a query to fetch only the first 10 records from the customers table.

22

Write a query to fetch all employees whose salary is greater than 50,000.

23

Write a query to find employees hired between two specific dates

24

Write a query to fetch records where the name starts with ‘A’.

25

Write a query to retrieve customers who do not have an email.

26

Write a query to get employee names along with their department names using INNER JOIN.

27

Write a query to get all customers and their orders using LEFT JOIN.

28

Write a query to list customers who have not placed any orders using RIGHT JOIN or NOT EXISTS.

29

Write a query to find the total sales per product.

30

Write a query to find the average salary per department.

31

Write a query to get the maximum and minimum salary in the company.

32

Write a query to find departments with more than 5 employees.

33

Write a query to count number of orders placed each day.

34

Write a query to find employees who earn more than the average salary.

35

Write a query to list customers who placed the highest number of orders.

36

Write a query to fetch the second highest salary using subquery.

37

Write a query to find products not ordered by any customer.

38

Write a query to fetch top 5 highest paid employees.

39

Write a query to get orders placed in the last 7 days.

40

Write a query to concatenate first name and last name.

41

Write a query to fetch top 3 salaried employees in each department.

Online Learner helps developers master programming, database concepts, interview preparation, and real-world implementation through structured learning paths.

Quick Links

Company

© 2023 - 2026 OnlineLearner.in | All Rights Reserved.