w1coding.comAll tutorials

SQL Where

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 WHERE Clause

The WHERE clause is used to filter records based on specified conditions.

Query with WHERE Clause

SELECT first_name, last_name FROM Users
WHERE age > 18;
    

This query retrieves the first and last names of users who are older than 18 years.