Як вибрати всі записи з таблиці "employees", де заробітна плата (колонка "salary") не перебуває в діапазоні від 40000 до 60000?

Question

Accepted Answer

SELECT * FROM employees WHERE salary NOT BETWEEN 40000 AND 60000

Answer

SELECT * FROM employees WHERE salary NOT IN (40000, 60000)

Answer

SELECT * FROM employees WHERE salary < 40000 OR salary > 60000

Answer

SELECT * FROM employees WHERE salary != 40000 AND salary != 60000

Answer

SELECT * FROM employees WHERE salary <> 40000 AND salary <> 60000

Crowdly