Question

Which keyword yields the same results as using the >= and <= operators?

A. WHERE
B. BETWEEN
C. IS
D. LIKE

Answer 1

B. BETWEEN

Step-by-step explanation:

The keyword BETWEEN yields the same results as using the >= and <= operators in SQL. The BETWEEN keyword is used in a query to filter a range of values. It can be used to filter a range of values for a particular column, for example "SELECT * FROM table WHERE column BETWEEN value1 AND value2;", it will return all rows from the table where the value of column is greater than or equal to value1 and less than or equal to value2.