Link to home
Start Free TrialLog in
Avatar of Gordon Hughes
Gordon HughesFlag for United Kingdom of Great Britain and Northern Ireland

asked on

How toselect unique values

How do I correct this statement to get unique values
select unique Costcenter from EQUIP

Gordon
ASKER CERTIFIED SOLUTION
Avatar of Pawan Kumar
Pawan Kumar
Flag of India 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 Vitor Montalvão
Avoid using the DISTINCT keyword since is a performance killer.
A better way to do it is to use GROUP BY:
select Costcenter 
from EQUIP
GROUP BY Costcenter

Open in new window

Avatar of Gordon Hughes

ASKER

Works great