47 interview questions on SQL for developers (2026)

Easy

55 votes3797 runs0 comment

Write a SQL query to retrieve the list of employees with a salary greater than 5100.

Back-end developer

sql

select

where

Anonymous authorat Mar 30, 2023

Easy

21 votes3759 runs0 comment

Write a SQL query to insert data into a table

Back-end developer

sql

insert

Anonymous authorat Mar 27, 2023

Easy

21 votes3745 runs0 comment

Select only distinct values in a column using SQL

Back-end developer

sql

distinct

Anonymous authorat Mar 27, 2023

Easy

19 votes3648 runs1 comment

Update a column in an SQL table

Back-end developer

sql

update

Anonymous authorat Nov 7, 2023

Easy

17 votes3720 runs0 comment

Which SQL keyword is used to sort the result of a SELECT statement?

Back-end developer

sql

order by

Anonymous authorat Mar 27, 2023

Medium

14 votes3688 runs4 comments

Write the SQL query to delete a column from a table

Back-end developer

sql

table

column

Anonymous authorat Mar 27, 2023

Easy

11 votes3656 runs0 comment

How to delete an SQL table?

Back-end developer

sql

tables

Anonymous authorat Mar 27, 2023

Easy

11 votes3635 runs0 comment

Count the number of rows in an SQL table

Back-end developer

sql

count

Anonymous authorat Mar 27, 2023

Easy

11 votes3544 runs0 comment

Write a SQL query to retrieve the products with a price less than 1000 and sort the results in descending order of price.

Back-end developer

sql

order by

descending

Anonymous authorat Mar 28, 2023

Easy

10 votes3544 runs

2 comments

Write a SQL query to increase the salary of all employees by 10%.

Back-end developer

sql

update

salary

Anonymous authorat Mar 28, 2023

Easy

9 votes3722 runs

5 comments

Write an INNER JOIN query in SQL

Back-end developer

sql

join

Anonymous authorat Mar 27, 2023

Medium

9 votes3104 runs2 comments

Write a SQL query to get the order_id and total number of items for each order.

Back-end developer

sql

join

group by

Anonymous authorat Jan 2, 2024

Easy

8 votes3468 runs0 comment

Write a SQL query to get the total order amount for each customer.

Back-end developer

sql

sum

group by

Anonymous authorat Mar 28, 2023

Easy

8 votes3227 runs1 comment

Write a SQL query to retrieve employees with a salary higher than the average salary.

Back-end developer

sql

average

select

Anonymous authorat Mar 28, 2023

Easy

6 votes3548 runs0 comment

Write a SQL query to calculate the total quantities sold for each product_id.

Back-end developer

sql

sum

group by

Anonymous authorat Mar 28, 2023

Easy

6 votes1146 runs0 comment

Write a SQL query to get the total sales quantity for each product.

Back-end developer

sql

sum

group by

JOHANat Jul 19, 2024

Easy

5 votes3665 runs

9 comments

Which SQL keyword is used to filter the results of a SELECT statement based on a specified condition?

Back-end developer

sql

select

where

Anonymous authorat Mar 27, 2023

Easy

4 votes1117 runs1 comment

Write the SQL code to create a table with a primary key

Back-end developer

sql

primary key

Anonymous authorat Nov 15, 2023

Easy

3 votes772 runs0 comment

Which SQL command allows you to define a constraint on the range of values of a column when creating a table?

Back-end developer

sql

constraints

Louis Prevosteauat May 15, 2023

Hard

3 votes692 runs0 comment

Write a SQL query to get the average of the number of orders per customer.

Data Scientist

sql

error

Clément Devosat Dec 2, 2021

47 interview questions on SQLfor developers (2026)

Test your technical skills before an interview of SQL with 47 corrected questions. Beginner, Intermediate or Expert level.

Write a SQL query to retrieve the list of employees with a salary greater than 5100.

Write a SQL query to insert data into a table

Select only distinct values in a column using SQL

Update a column in an SQL table

Which SQL keyword is used to sort the result of a SELECT statement?

Write the SQL query to delete a column from a table

How to delete an SQL table?

Count the number of rows in an SQL table

Write a SQL query to retrieve the products with a price less than 1000 and sort the results in descending order of price.

Write a SQL query to increase the salary of all employees by 10%.

Write an INNER JOIN query in SQL

Write a SQL query to get the order_id and total number of items for each order.

Write a SQL query to get the total order amount for each customer.

Write a SQL query to retrieve employees with a salary higher than the average salary.

Write a SQL query to calculate the total quantities sold for each product_id.

Write a SQL query to get the total sales quantity for each product.

Which SQL keyword is used to filter the results of a SELECT statement based on a specified condition?

Write the SQL code to create a table with a primary key

Which SQL command allows you to define a constraint on the range of values of a column when creating a table?

Write a SQL query to get the average of the number of orders per customer.