Question

Category table has an id field of type integer. Which of the queries will return the same result as the following one:


SELECT * FROM category WHERE id BETWEEN 2 and 4

Select all the apply.

Cosmo · Accepted Answer

BETWEEN operator selects values within a given range. It is inclusive operator: begin and end values are included.

Cosmo · Accepted Answer

SELECT * FROM category WHERE id>=2 AND id<=4

Cosmo · Accepted Answer

SELECT * FROM category WHERE id IN (2,3,4)

Cosmo · Answer

SELECT * FROM category WHERE id BETWEEN 4 and 2

Cosmo · Answer

SELECT * FROM category WHERE id >= 2 AND <=4

Cosmo · Answer

SELECT * FROM category WHERE id>2 and id<4

Cosmo · Answer

SELECT * FROM category WHERE id IN (2..4)

Cosmo · Answer

SELECT * FROM category WHERE id LIKE 2..4