Питання | Сторінка 138290

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

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

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

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

SELECT * FROM Categories WHERE CategoryID BETWEEN 5 OR 8

SELECT * FROM Categories WHERE CategoryID BETWEEN 5 AND 8

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

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

Переглянути це питання

Crowdly