sql server 2000, writing a query where each key will show only once 1

[pssheba]

Hi !
My code is such as:

select phone from myphones

if some tel. numbers show more than once, i want it to appear once only.
Is that possible ?
Thanks !

 

[AngelB]

You need the DISTINCT keyword:

select distinct phone from myphones

Hope this helps


Geraint

The lights are on but nobody's home, my elevator doesn't go to the top. I'm not playing with a full deck, I've lost my marbles. Barenaked Ladies - Crazy

 

[pssheba]

Thanks a lot !