w1coding.comAll tutorials

SQL Operator

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

The BETWEEN operator is used to filter records within a specific range (inclusive).

Example of BETWEEN

SELECT first_name, last_name FROM Users
WHERE age BETWEEN 18 AND 30;
    

This query retrieves the names of users who are between 18 and 30 years old.