Operador IN en SQL

Опубликовано: 05 Март 2026
на канале: May Code

421

SELECT customer_id, rental_id, return_date
FROM rental
WHERE customer_id IN (1, 2)
ORDER BY return_date DESC;

SELECT customer_id, rental_id, return_date
FROM rental
WHERE customer_id NOT IN (1, 2);

SELECT customer_id, rental_id, return_date
FROM rental
WHERE customer_id IN (SELECT customer_id FROM customer WHERE active = 1 );