jumpstart0321
asked on
Advanced Sql Select statement
I have a database of 1.6 million products, all of them pertaining to a certain "category" that wasn't even set forth by me. Is there a specific statement I can do to get all the categories only once? For example, the results to be:
computers
art
electronics
software
NOT:
computers
computers
art
computers
software
software
computers
art
electronics
software
NOT:
computers
computers
art
computers
software
software
group by category?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
DISTINCT did it. Thanks :)