Fill the blanks with suitable options?
BETWEEN . . . . . . . . AND . . . . . . . .

Solution (By Examveda Team)

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;