w1coding.comAll tutorials

SQL Decision

SQL lessons
  1. Environment Setup
  2. Introduction
  3. Select
  4. Where
  5. Decision
  6. Insert
  7. Delete
  8. Distinct
  9. Limit
  10. Operator
  11. In
  12. Join
  13. Leftjoin
  14. Rightjoin
  15. Fulljoin
  16. Groupby
  17. Having
  18. Order
  19. Update

SQL AND, OR, NOT Operators

SQL provides logical operators like AND, OR, and NOT to combine conditions in a query.

AND Operator

SELECT first_name, last_name FROM Users
WHERE age > 18 AND gender = 'Female';
    

This query retrieves the names of female users older than 18.

OR Operator

SELECT first_name, last_name FROM Users
WHERE age > 18 OR gender = 'Male';
    

This query retrieves the names of users who are either older than 18 or male.

NOT Operator

SELECT first_name, last_name FROM Users
WHERE NOT gender = 'Male';
    

This query retrieves the names of users who are not male.