Table
Category has a field 'Id' (integer data type). Which of the following queries
returns the same results as the query
below?

SELECT * FROM Category WHERE Id BETWEEN 2 AND 4

Question

Table
Category has a field 'Id' (integer data type). Which of the following queries
returns the same results as the  query
below?

SELECT  * FROM Category WHERE Id BETWEEN 2 AND 4

Answer

SELECT  * FROM Category WHERE Id IN (2,3,4)

Answer

SELECT  * FROM Category WHERE Id>=2 AND ID<=4

Answer

SELECT  * FROM Category WHERE Id >= 2 AND <=4

Answer

SELECT  * FROM Category WHERE Id IN (2..4)

Answer

SELECT  * FROM Category WHERE Id LIKE 2..4

Answer

SELECT  * FROM Category WHERE Id>2 AND ID<4

Answer

SELECT  * FROM Category WHERE Id BETWEEN 4 AND 2

Crowdly