47 interview questions on SQL for developers (2026)

Easy

55 votes3799 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 votes3761 runs0 comment

Write a SQL query to insert data into a table

Back-end developer

sql

insert

Anonymous authorat Mar 27, 2023

Easy

21 votes3747 runs0 comment

Select only distinct values in a column using SQL

Back-end developer

sql

distinct

Anonymous authorat Mar 27, 2023

Easy

19 votes3650 runs1 comment

Update a column in an SQL table

Back-end developer

sql

update

Anonymous authorat Nov 7, 2023

Easy

17 votes3722 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 votes3690 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 votes3658 runs0 comment

How to delete an SQL table?

Back-end developer

sql

tables

Anonymous authorat Mar 27, 2023

Easy

11 votes3637 runs0 comment

Count the number of rows in an SQL table

Back-end developer

sql

count

Anonymous authorat Mar 27, 2023

Easy

11 votes3546 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 votes3546 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 votes3724 runs

5 comments

Write an INNER JOIN query in SQL

Back-end developer

sql

join

Anonymous authorat Mar 27, 2023

Medium

9 votes3106 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 votes3470 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 votes3229 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 votes3550 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 votes1148 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 votes3667 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 votes1118 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.