Exercise v3.0

×

×

Correct!

Use the BETWEEN operator to select all the records where the value of the ProductName column is alphabetically between 'Geitost' and 'Pavlova'.

SELECT * FROM Products WHERE ProductName
@(31);

SELECT * FROM Products WHERE ProductName
BETWEEN 'Geitost' AND 'Pavlova';

SELECT * FROM Products WHERE ProductName
BETWEEN "Geitost" AND "Pavlova";

SELECT * FROM Products WHERE ProductName
BETWEEN 'Geitost' AND "Pavlova";

SELECT * FROM Products WHERE ProductName
BETWEEN "Geitost" AND 'Pavlova';

Not Correct

Click here to try again.

Correct!

Go to w3schools.com

Reset Score

Close This Menu

SQL Select

Exercise 1 Exercise 2 Exercise 3 Go to SQL Select Tutorial

SQL Where

Exercise 1 Exercise 2 Exercise 3 Exercise 4 Exercise 5 Go to SQL Where Tutorial

SQL Order By

Exercise 1 Exercise 2 Exercise 3 Go to SQL Order By Tutorial

SQL Insert

Exercise 1 Go to SQL Insert Tutorial

SQL Null

Exercise 1 Exercise 2 Go to SQL Null Tutorial

SQL Update

Exercise 1 Exercise 2 Exercise 3 Go to SQL Update Tutorial

SQL Delete

Exercise 1 Exercise 2 Go to SQL Delete Tutorial

SQL Functions

Exercise 1 Exercise 2 Exercise 3 Exercise 4 Exercise 5 Go to SQL Functions Tutorial

SQL Like

Exercise 1 Exercise 2 Exercise 3 Exercise 4 Exercise 5 Go to SQL Like Tutorial

SQL Wildcards

Exercise 1 Exercise 2 Exercise 3 Exercise 4 Go to SQL Wildcards Tutorial

SQL In

Exercise 1 Exercise 2 Go to SQL In Tutorial

SQL Between

Exercise 1 Exercise 2 Exercise 3 Go to SQL Between Tutorial

SQL Alias

Exercise 1 Exercise 2 Go to SQL Alias Tutorial

SQL Join

Exercise 1 Exercise 2 Exercise 3 Go to SQL Join Tutorial

SQL Group By

Exercise 1 Exercise 2 Go to SQL Group By Tutorial

SQL Database

Exercise 1 Exercise 2 Exercise 3 Exercise 4 Exercise 5 Exercise 6 Exercise 7 Go to SQL Database Tutorial

×

Reset the Score?

This will reset the score of ALL 52 exercises.

Are you sure you want to continue?

×

Congratulations!

You have finished all 52 SQL exercises.

Share your score: