?
Fill the blanks with suitable options?
Fill the blanks with suitable options?
BETWEEN . . . . . . . . AND . . . . . . . .
Answer & Solution
Correct Answer:
Option
B
In MySQL, the BETWEEN keyword is used to select values within a specific range.
The BETWEEN operator needs two values: a lower limit and an upper limit.
Therefore, the correct answer is Option B: Lower and upper limit.
For example, if you want to select all rows where the age is between 18 and 30, you would use:
SELECT * FROM users WHERE age BETWEEN 18 AND 30;
The BETWEEN operator needs two values: a lower limit and an upper limit.
Therefore, the correct answer is Option B: Lower and upper limit.
For example, if you want to select all rows where the age is between 18 and 30, you would use:
SELECT * FROM users WHERE age BETWEEN 18 AND 30;
Join the Discussion
Login to post a comment or share your explanation.
Login