Job offersCompaniesTestsBlogI'm an employerSign upLog in
fr
fr
Home>IT Tests>Questions>SQL - Fundamentals

24 interview questions on SQL - Fundamentalsfor developers (2024)

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

or
Technology
Profession
Test
Sort by
Newest
Most popular
Last review
Filter by
Published
3562
To review
0
24 questions
Easy
19 votes1840 runs0 comment

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

Back-end developer
sql
select
where
Vincent Cotroat Mar 30, 2023
Easy
12 votes1771 runs1 comment

Update a column in an SQL table

Back-end developer
sql
update
Vincent Cotroat Nov 7, 2023
Easy
10 votes1816 runs0 comment

Select only distinct values in a column using SQL

Back-end developer
sql
distinct
Vincent Cotroat Mar 27, 2023
Easy
8 votes1809 runs0 comment

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

Back-end developer
sql
order by
Vincent Cotroat Mar 27, 2023
Medium
8 votes1767 runs3 comments

Write the SQL query to delete a column from a table

Back-end developer
sql
table
column
Vincent Cotroat Mar 27, 2023
Easy
7 votes1824 runs0 comment

Write a SQL query to insert data into a table

Back-end developer
sql
insert
Vincent Cotroat Mar 27, 2023
Easy
7 votes1730 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
Vincent Cotroat Mar 28, 2023
Easy
6 votes609 runs1 comment

Write a SQL query to retrieve the titles of books written by 'John Smith'.

Back-end developer
join
inner join
sql
Vincent Cotroat Sep 6, 2023
Easy
5 votes1804 runs2 comments

Write an INNER JOIN query in SQL

Back-end developer
sql
join
Vincent Cotroat Mar 27, 2023
Easy
4 votes1803 runs0 comment

How to delete an SQL table?

Back-end developer
sql
tables
Vincent Cotroat Mar 27, 2023
Easy
4 votes1392 runs0 comment

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

Back-end developer
sql
average
select
Vincent Cotroat Mar 28, 2023
Easy
2 votes1778 runs3 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
Vincent Cotroat Mar 27, 2023
Easy
2 votes1725 runs0 comment

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

Back-end developer
sql
sum
group by
Vincent Cotroat Mar 28, 2023
Easy
2 votes1718 runs0 comment

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

Back-end developer
sql
update
salary
Vincent Cotroat Mar 28, 2023
Easy
2 votes1691 runs0 comment

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

Back-end developer
sql
sum
group by
Vincent Cotroat Mar 28, 2023
Medium
2 votes1258 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
Vincent Cotroat Jan 2, 2024
Easy
2 votes501 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
Easy
2 votes93 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
1 vote1786 runs
3 comments

Write a SQL query to retrieve the names of students enrolled in the course with ID 1.

Back-end developer
join
inner join
sql
Vincent Cotroat Mar 28, 2023
Easy
1 vote1775 runs0 comment

Count the number of rows in an SQL table

Back-end developer
sql
count
Vincent Cotroat Mar 27, 2023