w1coding.comAll tutorials

SQL In

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 IN Operator

The IN operator is used to specify multiple values in a WHERE clause.

Example of IN

SELECT first_name, last_name FROM Users
WHERE gender IN ('Male', 'Female');
    

This query retrieves users whose gender is either 'Male' or 'Female'.