|
|
ORDER BYThe DISTINCT Clause selects only one of each valueSELECT DISTINCT (category) FROM People The SQL Statement above will retrieve All category values once: SELECT DISTINCT (category) From the table named People: FROM People If this is the original table
Your recordset returned would be this:
| |||||||||||||||||||||