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
3586
To review
14
24 questions
Easy
22 votes1971 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 votes1900 runs1 comment

Update a column in an SQL table

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

Select only distinct values in a column using SQL

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

Write a SQL query to insert data into a table

Back-end developer
sql
insert
Vincent Cotroat Mar 27, 2023
Easy
8 votes1939 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 votes1898 runs4 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 votes1854 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 votes728 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 votes1933 runs0 comment

How to delete an SQL table?

Back-end developer
sql
tables
Vincent Cotroat Mar 27, 2023
Easy
5 votes1514 runs1 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
4 votes1935 runs
3 comments

Write an INNER JOIN query in SQL

Back-end developer
sql
join
Vincent Cotroat Mar 27, 2023
Easy
3 votes205 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
2 votes1906 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 votes1846 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 votes1838 runs1 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 votes1810 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 votes1385 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 votes544 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
1 vote1912 runs3 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 vote1904 runs0 comment

Count the number of rows in an SQL table

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