The following structure of table is given on the image. Based on this structure please choose all answers which are suitable for solving next task:
display all categories when the CategoryID field is defined in interval [5..8] (end values are included)

Question

The following structure of table is given on the image. Based on this structure please choose all answers which are suitable for solving next task:

display all categories when the CategoryID field is defined in interval [5..8] (end values are included)

Table structure

Answer

SELECT  *  FROM  Categories  WHERE  CategoryID > 5  AND  CategoryID < 8

Answer

SELECT  *  FROM  Categories  WHERE  CategoryID  BETWEEN  5  OR  8

Answer

SELECT  *  FROM  Categories  WHERE  CategoryID  BETWEEN  5  AND  8

Answer

SELECT  *  FROM  Categories  WHERE  CategoryID  IN  [5,6,7,8]

Answer

SELECT  *  FROM  Categories  WHERE  CategoryID > 4  AND  CategoryID < 9

Answer

SELECT  *  FROM  Categories  WHERE  CategoryID >= 5  AND  CategoryID <= 8

Answer

SELECT  *  FROM  Categories  WHERE  CategoryID  IN  (5,6,7,8)

Crowdly