W3. SQL Between

Question 1

Q: What does the SQL BETWEEN operator do?

Answer 1

A: It selects values within a specified range, including the start and end values.

Question 2

Q: Write a query to select all products with a price between 10 and 20.

Answer 2

SELECT * FROM Products
WHERE Price BETWEEN 10 AND 20;

Question 3

Q: What is the syntax for the BETWEEN operator in SQL?

Answer 3

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

Question 4

Q: How do you select values outside a range using BETWEEN?

Answer 4

A: Use NOT BETWEEN, e.g., WHERE Price NOT BETWEEN 10 AND 20.

Question 5

Q: Write a query to select all products with a price outside the range 10 to 20.

Answer 5

SELECT * FROM Products
WHERE Price NOT BETWEEN 10 AND 20;

Question 6

Q: Can BETWEEN be combined with IN in SQL?

Answer 6

A: Yes, you can add IN to further filter values within the specified range.

Question 7

Q: Write a query to select products with a price between 10 and 20 and a CategoryID of 1, 2, or 3.

Answer 7

SELECT * FROM Products
WHERE Price BETWEEN 10 AND 20
AND CategoryID IN (1,2,3);

Question 8

Q: How can BETWEEN be used with text values?

Answer 8

A: It can select records in alphabetical order within a specified range of text values.

Question 9

Q: Write a query to select products with ProductName alphabetically between “Carnarvon Tigers” and “Mozzarella di Giovanni”.

Answer 9

SELECT * FROM Products
WHERE ProductName BETWEEN ‘Carnarvon Tigers’ AND ‘Mozzarella di Giovanni’
ORDER BY ProductName;

Question 10

Q: How do you exclude text values within a range using BETWEEN?

Answer 10

A: Use NOT BETWEEN with text values, e.g., WHERE ProductName NOT BETWEEN ‘Carnarvon Tigers’ AND ‘Mozzarella di Giovanni’.

Question 11

Q: Write a query to select products with ProductName not between “Carnarvon Tigers” and “Mozzarella di Giovanni”.

Answer 11

SELECT * FROM Products
WHERE ProductName NOT BETWEEN ‘Carnarvon Tigers’ AND ‘Mozzarella di Giovanni’
ORDER BY ProductName;

Question 12

Q: Can BETWEEN be used with dates?

Answer 12

A: Yes, it can select dates within a specified range, including start and end dates.

Question 13

Q: Write a query to select all orders with OrderDate between ‘1996-07-01’ and ‘1996-07-31’.

Answer 13

SELECT * FROM Orders
WHERE OrderDate BETWEEN ‘1996-07-01’ AND ‘1996-07-31’;