Logical Operators: AND, OR, NOT

Published July 26, 2025 By Sai Sree Ram Gundepudi

Logical Operators: AND, OR, NOT

AND

SELECT * FROM employees WHERE department_id = 50 AND salary > 3000;

OR

SELECT * FROM employees WHERE department_id = 50 OR department_id = 60;

NOT

SELECT * FROM employees WHERE NOT job_id = 'SA_REP';

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article