SQL AND / OR / NOT

Add W3Buddy as a preferred source on Google

हि En

🔊 Listen

Use AND, OR, and NOT to build complex filters in your WHERE clause.

🔹 How They Work

• AND — all conditions must be true
• OR — at least one condition is true
• NOT — reverses the condition (negation)

🔹 Examples

-- Both conditions must be true
SELECT * FROM employees 
WHERE department = 'IT' AND salary > 60000;

-- Either condition can be true
SELECT * FROM employees 
WHERE department = 'HR' OR salary > 70000;

-- Negate a condition
SELECT * FROM employees 
WHERE NOT department = 'Sales';

-- Combine all
SELECT * FROM employees 
WHERE (department = 'IT' OR department = 'HR') AND salary > 50000;

🧠 Quick Recap

✅ Use these to filter data precisely and flexibly!