Duplicate Query

[rblivewire]

I need a query that displays only 1 number from a duplicate. Ex. If I
have 3 "1000", it only displays one of them. Any suggestions?

 

[Darren]

Select Distinct [number] from