w1coding.comAll tutorials

SQL Distinct

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 DISTINCT Keyword

The DISTINCT keyword is used to return only distinct (different) values in the result set.

Example of DISTINCT

SELECT DISTINCT gender FROM Users;
    

This query retrieves the unique values from the "gender" column in the "Users" table.