Test Your Microsoft SQL Server BETWEEN Operator Knowledge with This Quiz

Progress

True / False

The BETWEEN operator includes both boundary values in the range.

True False

The BETWEEN operator is inclusive, meaning it includes the boundary values in the range.

True / False

The BETWEEN operator can only be used with numeric values.

True False

The BETWEEN operator can be used with numeric values, dates, and text.

True / False

The query 'SELECT * FROM Products WHERE Price BETWEEN 50 AND 150;' will include products priced at exactly 50 and 150.

SQL Code

SELECT * FROM Products
WHERE Price BETWEEN 50 AND 150;

True False

The BETWEEN operator is inclusive, so it will include products priced at 50 and 150.

True / False

The BETWEEN operator cannot be used with text values.

True False

The BETWEEN operator can be used with text values to filter based on alphabetical range.

True / False

The query 'SELECT * FROM Orders WHERE OrderDate BETWEEN '2023-01-01' AND '2023-06-30';' will include orders placed on '2023-06-30'.

SQL Code

SELECT * FROM Orders
WHERE OrderDate BETWEEN '2023-01-01' AND '2023-06-30';

True False

The BETWEEN operator includes the boundary values, so orders placed on '2023-06-30' will be included.

True / False

Using the BETWEEN operator with dates requires the dates to be in the format 'YYYY-MM-DD'.

True False

The dates should be in a recognized date format, and 'YYYY-MM-DD' is a common format used in SQL Server.

True / False

The query 'SELECT * FROM Employees WHERE Age BETWEEN 30 AND 40;' will not include employees aged exactly 30 or 40.

SQL Code

SELECT * FROM Employees
WHERE Age BETWEEN 30 AND 40;

True False

The BETWEEN operator is inclusive, so it will include employees aged exactly 30 and 40.

True / False

The BETWEEN operator can be used in conjunction with other operators like AND and OR.

True False

The BETWEEN operator can be used alongside other SQL operators to form complex conditions.

True / False

Using the BETWEEN operator on a column with NULL values will exclude those rows from the result.

True False

The BETWEEN operator does not consider NULL values. Rows with NULL values in the column will not be included in the result.

Q10

True / False

The query 'SELECT * FROM Sales WHERE TransactionAmount BETWEEN 1000 AND 5000;' will include transactions of exactly 1000 and 5000.

SQL Code

SELECT * FROM Sales
WHERE TransactionAmount BETWEEN 1000 AND 5000;

True False

The BETWEEN operator is inclusive, so it will include transactions of exactly 1000 and 5000.

Q11

True / False

The BETWEEN operator can be used to filter rows based on a range of character values.

True False

The BETWEEN operator can be used with character values to filter rows based on alphabetical range.

Q12

True / False

In the query 'SELECT * FROM Products WHERE Price BETWEEN 50 AND 150;', the result will exclude prices of 50 and 150.

SQL Code

SELECT * FROM Products
WHERE Price BETWEEN 50 AND 150;

True False

The BETWEEN operator includes the boundary values, so prices of 50 and 150 will be included.

Q13

True / False

The BETWEEN operator cannot be used with columns of type DATETIME.

True False

The BETWEEN operator can be used with DATETIME columns to filter rows based on a range of dates and times.

Q14

True / False

In the query 'SELECT * FROM Employees WHERE HireDate BETWEEN '2022-01-01' AND '2022-12-31';', the result will include employees hired on '2022-12-31'.

SQL Code

SELECT * FROM Employees
WHERE HireDate BETWEEN '2022-01-01' AND '2022-12-31';

True False

The BETWEEN operator includes the boundary values, so employees hired on '2022-12-31' will be included.

Q15

True / False

The BETWEEN operator can be used to filter rows based on a range of numeric values only.

True False

The BETWEEN operator can be used with numeric values, dates, and text values.

Q16

Single Choice

Which query will correctly retrieve products priced between $50 and $150?

SQL Code

SELECT * FROM Products
WHERE Price BETWEEN 50 AND 150;

SELECT * FROM Products WHERE Price BETWEEN 50 AND 150; SELECT * FROM Products WHERE Price > 50 AND Price < 150; SELECT * FROM Products WHERE Price >= 50 AND Price <= 150;SELECT * FROM Products WHERE Price = 50 OR Price = 150;

The BETWEEN operator includes both boundary values in the range.

Q17

Single Choice

Which of the following is true about the BETWEEN operator?

It is exclusive of the boundary values. It can only be used with numeric data. It can be used with numeric, date, and text data.It cannot be used with date values.

The BETWEEN operator is inclusive and can be used with various data types.

Q18

Single Choice

What will be the result of the following query? SELECT * FROM Orders WHERE OrderDate BETWEEN '2023-01-01' AND '2023-12-31';

SQL Code

SELECT * FROM Orders
WHERE OrderDate BETWEEN '2023-01-01' AND '2023-12-31';

Orders placed on '2023-01-01' only Orders placed on '2023-12-31' only Orders placed between '2023-01-01' and '2023-12-31' excluding the boundary datesOrders placed between '2023-01-01' and '2023-12-31' inclusive

The query will include all orders placed from '2023-01-01' to '2023-12-31' inclusive.

Q19

Single Choice

How does the BETWEEN operator handle NULL values?

It includes rows with NULL values in the column. It excludes rows with NULL values in the column. It treats NULL as a valid range boundary.It causes an error when NULL values are present.

The BETWEEN operator does not consider NULL values in the column.

Q20

Single Choice

Which query will retrieve employees hired between '2022-01-01' and '2022-12-31' inclusive?

SQL Code

SELECT * FROM Employees
WHERE HireDate BETWEEN '2022-01-01' AND '2022-12-31';

SELECT * FROM Employees WHERE HireDate > '2022-01-01' AND HireDate < '2022-12-31'; SELECT * FROM Employees WHERE HireDate >= '2022-01-01' AND HireDate <= '2022-12-31'; SELECT * FROM Employees WHERE HireDate = '2022-01-01' OR HireDate = '2022-12-31';SELECT * FROM Employees WHERE HireDate BETWEEN '2022-01-01' AND '2022-12-31';

The BETWEEN operator includes both boundary dates.

Q21

Single Choice

In the query 'SELECT * FROM Products WHERE Price BETWEEN 100 AND 200;', which prices are included?

SQL Code

SELECT * FROM Products
WHERE Price BETWEEN 100 AND 200;

Prices greater than 100 and less than 200 Prices equal to 100 and 200 only Prices from 100 to 200 inclusivePrices greater than 100 and up to 200

The BETWEEN operator includes the boundary values, so prices of 100 and 200 are included.

Q22

Single Choice

Which query will correctly retrieve records for dates between '2021-01-01' and '2021-12-31'?

SQL Code

SELECT * FROM Records
WHERE RecordDate BETWEEN '2021-01-01' AND '2021-12-31';

SELECT * FROM Records WHERE RecordDate BETWEEN '2021-01-01' AND '2021-12-31'; SELECT * FROM Records WHERE RecordDate > '2021-01-01' AND RecordDate < '2021-12-31'; SELECT * FROM Records WHERE RecordDate >= '2021-01-01' AND RecordDate <= '2021-12-31';SELECT * FROM Records WHERE RecordDate = '2021-01-01' OR RecordDate = '2021-12-31';

The BETWEEN operator includes both boundary values in the range.

Q23

Single Choice

How can you modify the query 'SELECT * FROM Sales WHERE Amount BETWEEN 1000 AND 5000;' to exclude the boundary values?

SQL Code

SELECT * FROM Sales
WHERE Amount BETWEEN 1000 AND 5000;

SELECT * FROM Sales WHERE Amount > 1000 AND Amount < 5000; SELECT * FROM Sales WHERE Amount >= 1000 AND Amount <= 5000; SELECT * FROM Sales WHERE Amount = 1000 OR Amount = 5000;SELECT * FROM Sales WHERE Amount NOT BETWEEN 1000 AND 5000;

To exclude the boundary values, use '>' and '<' instead of BETWEEN.

Q24

Single Choice

Which of the following queries will include dates '2023-01-01' and '2023-12-31'?

SQL Code

SELECT * FROM Events
WHERE EventDate BETWEEN '2023-01-01' AND '2023-12-31';

SELECT * FROM Events WHERE EventDate > '2023-01-01' AND EventDate < '2023-12-31'; SELECT * FROM Events WHERE EventDate BETWEEN '2023-01-01' AND '2023-12-31'; SELECT * FROM Events WHERE EventDate = '2023-01-01' OR EventDate = '2023-12-31';SELECT * FROM Events WHERE EventDate BETWEEN '2023-01-02' AND '2023-12-30';

The BETWEEN operator includes both boundary dates.

Q25

Single Choice

What will be the result of the query 'SELECT * FROM Inventory WHERE Quantity BETWEEN 10 AND 20;'?

SQL Code

SELECT * FROM Inventory
WHERE Quantity BETWEEN 10 AND 20;

Quantities greater than 10 and less than 20 Quantities from 10 to 20 inclusive Quantities equal to 10 or 20 onlyQuantities greater than 10 and up to 20

The BETWEEN operator includes both boundary values, so it will return quantities from 10 to 20 inclusive.

Q26

Single Choice

How does the BETWEEN operator treat date ranges?

It excludes the boundary dates. It includes the boundary dates. It includes the start date but excludes the end date.It excludes the start date but includes the end date.

The BETWEEN operator includes both boundary dates in the range.

Q27

Single Choice

Which query will retrieve employees aged between 25 and 30 inclusive?

SQL Code

SELECT * FROM Employees
WHERE Age BETWEEN 25 AND 30;

SELECT * FROM Employees WHERE Age BETWEEN 25 AND 30; SELECT * FROM Employees WHERE Age > 25 AND Age < 30; SELECT * FROM Employees WHERE Age >= 25 AND Age <= 30;SELECT * FROM Employees WHERE Age = 25 OR Age = 30;

The BETWEEN operator includes both boundary values.

Q28

Single Choice

Which query will correctly filter products with prices between $100 and $500?

SQL Code

SELECT * FROM Products
WHERE Price BETWEEN 100 AND 500;

SELECT * FROM Products WHERE Price > 100 AND Price < 500; SELECT * FROM Products WHERE Price BETWEEN 100 AND 500; SELECT * FROM Products WHERE Price >= 100 AND Price <= 500;SELECT * FROM Products WHERE Price = 100 OR Price = 500;

The BETWEEN operator includes both boundary values in the range.

Q29

Single Choice

Which query will retrieve orders placed between '2022-01-01' and '2022-12-31'?

SQL Code

SELECT * FROM Orders
WHERE OrderDate BETWEEN '2022-01-01' AND '2022-12-31';

SELECT * FROM Orders WHERE OrderDate BETWEEN '2022-01-01' AND '2022-12-31'; SELECT * FROM Orders WHERE OrderDate > '2022-01-01' AND OrderDate < '2022-12-31'; SELECT * FROM Orders WHERE OrderDate >= '2022-01-01' AND OrderDate <= '2022-12-31';SELECT * FROM Orders WHERE OrderDate = '2022-01-01' OR OrderDate = '2022-12-31';

The BETWEEN operator includes both boundary dates.

Q30

Single Choice

How can you modify the query 'SELECT * FROM Events WHERE EventDate BETWEEN '2023-01-01' AND '2023-12-31';' to exclude the boundary dates?

SQL Code

SELECT * FROM Events
WHERE EventDate BETWEEN '2023-01-01' AND '2023-12-31';

SELECT * FROM Events WHERE EventDate > '2023-01-01' AND EventDate < '2023-12-31'; SELECT * FROM Events WHERE EventDate >= '2023-01-01' AND EventDate <= '2023-12-31'; SELECT * FROM Events WHERE EventDate = '2023-01-01' OR EventDate = '2023-12-31';SELECT * FROM Events WHERE EventDate NOT BETWEEN '2023-01-01' AND '2023-12-31';

To exclude the boundary dates, use '>' and '<' instead of BETWEEN.

Q31

Multiple Choice

Which of the following queries will correctly retrieve records for dates between '2021-01-01' and '2021-12-31'?

SQL Code

SELECT * FROM Records
WHERE RecordDate BETWEEN '2021-01-01' AND '2021-12-31';

The BETWEEN operator includes both boundary values in the range.

Q32

Multiple Choice

Which queries will retrieve products priced between $100 and $200?

SQL Code

SELECT * FROM Products
WHERE Price BETWEEN 100 AND 200;

SELECT * FROM Products WHERE Price BETWEEN 100 AND 200; SELECT * FROM Products WHERE Price > 100 AND Price < 200; SELECT * FROM Products WHERE Price >= 100 AND Price <= 200;SELECT * FROM Products WHERE Price = 100 OR Price = 200;

The BETWEEN operator includes both boundary values in the range.

Q33

Multiple Choice

Which of the following queries correctly use the BETWEEN operator with dates?

SQL Code

SELECT * FROM Events
WHERE EventDate BETWEEN '2023-01-01' AND '2023-12-31';

SELECT * FROM Events WHERE EventDate BETWEEN '2023-01-01' AND '2023-12-31'; SELECT * FROM Events WHERE EventDate > '2023-01-01' AND EventDate < '2023-12-31'; SELECT * FROM Events WHERE EventDate >= '2023-01-01' AND EventDate <= '2023-12-31';SELECT * FROM Events WHERE EventDate = '2023-01-01' OR EventDate = '2023-12-31';

The BETWEEN operator can be used with dates and includes both boundary values.

Q34

Multiple Choice

Which queries will include prices of 50 and 150?

SQL Code

SELECT * FROM Products
WHERE Price BETWEEN 50 AND 150;

The BETWEEN operator is inclusive and includes both boundary values.

Q35

Multiple Choice

Which queries will retrieve employees aged between 25 and 35 inclusive?

SQL Code

SELECT * FROM Employees
WHERE Age BETWEEN 25 AND 35;

SELECT * FROM Employees WHERE Age BETWEEN 25 AND 35; SELECT * FROM Employees WHERE Age > 25 AND Age < 35; SELECT * FROM Employees WHERE Age >= 25 AND Age <= 35;SELECT * FROM Employees WHERE Age = 25 OR Age = 35;

The BETWEEN operator includes both boundary values.

Q36

Multiple Choice

Which of the following queries will correctly retrieve records for a range of character values?

SQL Code

SELECT * FROM Records
WHERE RecordName BETWEEN 'A' AND 'M';

SELECT * FROM Records WHERE RecordName BETWEEN 'A' AND 'M'; SELECT * FROM Records WHERE RecordName > 'A' AND RecordName < 'M'; SELECT * FROM Records WHERE RecordName >= 'A' AND RecordName <= 'M';SELECT * FROM Records WHERE RecordName = 'A' OR RecordName = 'M';

The BETWEEN operator can be used with character values and includes both boundary values.

Q37

Multiple Choice

Which queries correctly use the BETWEEN operator with date and time values?

SQL Code

SELECT * FROM Events
WHERE EventDateTime BETWEEN '2023-01-01 00:00:00' AND '2023-12-31 23:59:59';

SELECT * FROM Events WHERE EventDateTime BETWEEN '2023-01-01 00:00:00' AND '2023-12-31 23:59:59'; SELECT * FROM Events WHERE EventDateTime > '2023-01-01 00:00:00' AND EventDateTime < '2023-12-31 23:59:59'; SELECT * FROM Events WHERE EventDateTime >= '2023-01-01 00:00:00' AND EventDateTime <= '2023-12-31 23:59:59';SELECT * FROM Events WHERE EventDateTime = '2023-01-01 00:00:00' OR EventDateTime = '2023-12-31 23:59:59';

The BETWEEN operator can be used with date and time values and includes both boundary values.

Q38

Multiple Choice

Which of the following queries will retrieve products with IDs between 1 and 100 inclusive?

SQL Code

SELECT * FROM Products
WHERE ProductID BETWEEN 1 AND 100;

SELECT * FROM Products WHERE ProductID BETWEEN 1 AND 100; SELECT * FROM Products WHERE ProductID > 1 AND ProductID < 100; SELECT * FROM Products WHERE ProductID >= 1 AND ProductID <= 100;SELECT * FROM Products WHERE ProductID = 1 OR ProductID = 100;

The BETWEEN operator includes both boundary values.

Q39

Multiple Choice

Which queries will correctly retrieve sales amounts between 500 and 1000?

SQL Code

SELECT * FROM Sales
WHERE Amount BETWEEN 500 AND 1000;

SELECT * FROM Sales WHERE Amount BETWEEN 500 AND 1000; SELECT * FROM Sales WHERE Amount > 500 AND Amount < 1000; SELECT * FROM Sales WHERE Amount >= 500 AND Amount <= 1000;SELECT * FROM Sales WHERE Amount = 500 OR Amount = 1000;

The BETWEEN operator includes both boundary values in the range.

Q40

Multiple Choice

Which of the following queries will retrieve students with scores between 80 and 90?

SQL Code

SELECT * FROM Students
WHERE Score BETWEEN 80 AND 90;

SELECT * FROM Students WHERE Score BETWEEN 80 AND 90; SELECT * FROM Students WHERE Score > 80 AND Score < 90; SELECT * FROM Students WHERE Score >= 80 AND Score <= 90;SELECT * FROM Students WHERE Score = 80 OR Score = 90;

The BETWEEN operator includes both boundary values.

Q41

Multiple Choice

Which of the following queries will correctly filter records with date ranges?

SQL Code

SELECT * FROM Records
WHERE RecordDate BETWEEN '2022-01-01' AND '2022-12-31';

SELECT * FROM Records WHERE RecordDate BETWEEN '2022-01-01' AND '2022-12-31'; SELECT * FROM Records WHERE RecordDate > '2022-01-01' AND RecordDate < '2022-12-31'; SELECT * FROM Records WHERE RecordDate >= '2022-01-01' AND RecordDate <= '2022-12-31';SELECT * FROM Records WHERE RecordDate = '2022-01-01' OR RecordDate = '2022-12-31';

The BETWEEN operator includes both boundary dates in the range.

Q42

Multiple Choice

Which queries will correctly retrieve customers aged between 18 and 25 inclusive?

SQL Code

SELECT * FROM Customers
WHERE Age BETWEEN 18 AND 25;

SELECT * FROM Customers WHERE Age BETWEEN 18 AND 25; SELECT * FROM Customers WHERE Age > 18 AND Age < 25; SELECT * FROM Customers WHERE Age >= 18 AND Age <= 25;SELECT * FROM Customers WHERE Age = 18 OR Age = 25;

The BETWEEN operator includes both boundary values.

Q43

Multiple Choice

Which queries will retrieve orders placed between '2023-01-01' and '2023-12-31'?

SQL Code

SELECT * FROM Orders
WHERE OrderDate BETWEEN '2023-01-01' AND '2023-12-31';

SELECT * FROM Orders WHERE OrderDate BETWEEN '2023-01-01' AND '2023-12-31'; SELECT * FROM Orders WHERE OrderDate > '2023-01-01' AND OrderDate < '2023-12-31'; SELECT * FROM Orders WHERE OrderDate >= '2023-01-01' AND OrderDate <= '2023-12-31';SELECT * FROM Orders WHERE OrderDate = '2023-01-01' OR OrderDate = '2023-12-31';

The BETWEEN operator includes both boundary dates in the range.

Q44

Multiple Choice

Which of the following queries will correctly retrieve product IDs between 100 and 200 inclusive?

SQL Code

SELECT * FROM Products
WHERE ProductID BETWEEN 100 AND 200;

SELECT * FROM Products WHERE ProductID BETWEEN 100 AND 200; SELECT * FROM Products WHERE ProductID > 100 AND ProductID < 200; SELECT * FROM Products WHERE ProductID >= 100 AND ProductID <= 200;SELECT * FROM Products WHERE ProductID = 100 OR ProductID = 200;

The BETWEEN operator includes both boundary values.

Q45

Multiple Choice

Which of the following queries will include scores between 70 and 85 inclusive?

SQL Code

SELECT * FROM Scores
WHERE Score BETWEEN 70 AND 85;

SELECT * FROM Scores WHERE Score BETWEEN 70 AND 85; SELECT * FROM Scores WHERE Score > 70 AND Score < 85; SELECT * FROM Scores WHERE Score >= 70 AND Score <= 85;SELECT * FROM Scores WHERE Score = 70 OR Score = 85;

The BETWEEN operator includes both boundary values in the range.

Microsoft SQL Server Database Quiz Questions