Link to home
Start Free TrialLog in
Avatar of jumpstart0321
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
Avatar of QPR
QPR
Flag of New Zealand image

group by category?
ASKER CERTIFIED SOLUTION
Avatar of RWrigley
RWrigley
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jumpstart0321
jumpstart0321

ASKER

DISTINCT did it. Thanks :)