What are some examples of Boolean logic in SQL?

What are some examples of Boolean logic in SQL?

Boolean logic in SQL involves using operators like AND, OR, and NOT to filter records. For example, you can use SELECT * FROM users WHERE age > 18 AND city = 'New York'; to find users over 18 in New York.

Can you give me another example using OR?

Sure! You can use SELECT * FROM products WHERE category = 'Electronics' OR category = 'Books'; to retrieve products that are either in Electronics or Books.

What about using NOT?

Absolutely! An example would be SELECT * FROM employees WHERE NOT department = 'Sales'; which retrieves all employees not in the Sales department.

How can I combine these operators?

You can combine them like this: SELECT * FROM orders WHERE status = 'Shipped' AND NOT payment_status = 'Pending'; This retrieves shipped orders that are not pending payment.