Question

Which query is equivalent to the following one:

SELECT * FROM product WHERE price BETWEEN 100 AND 200;

Select all that apply.

Cosmo · Accepted Answer

BETWEEN operator selects values within a given range. The values can be numbers, text, or dates.
BETWEEN operator is inclusive: begin and end values are included.

Cosmo · Accepted Answer

SELECT * FROM product WHERE price >= 100 AND price <= 200;

Cosmo · Answer

SELECT * FROM product WHERE price < 100 OR price > 200;

Cosmo · Answer

SELECT * FROM product WHERE price <= 100 OR price >= 200;

Cosmo · Answer

SELECT * FROM product WHERE price > 100 AND price < 200;

Cosmo · Answer

SELECT * FROM product WHERE price > 100 OR price < 200;

Cosmo · Answer

SELECT * FROM product WHERE price >= 100 OR price <= 200;

Следи за CodeGalaxy

Мобильное приложение Beta