Operador BETWEEN

Опубликовано: 14 Июль 2026
на канале: May Code

306

Sirve para evaluar si un valor se encuentra dentro de un rango de valores.

La sintaxis es:
valor BETWEEN limite_inferior AND limite_superior;
valor NOT BETWEEN limite_inferior AND limite_superior;

SELECT customer_id, payment_id, amount
FROM payment
WHERE amount BETWEEN 8 AND 9;

SELECT customer_id, payment_id, amount
FROM payment
WHERE amount NOT BETWEEN 8 AND 9;

SELECT customer_id, payment_id, amount, payment_date
FROM payment
WHERE payment_date BETWEEN '2007-02-07' AND '2007-02-15';

SELECT first_name, RIGHT(first_name, 1) final
FROM actor
WHERE RIGHT(first_name, 1) BETWEEN 'a' AND 'e';