how to select 100 differents rows in ms sql server?

Question

I have a table with almost 50,000 telephone numbers. I need to select 100 different telephone numbers ... any help ??

Thank you.

Answer 1

In each row, is the telephone number unique? If so, the just:


SELECT TOP 100 * FROM TELEPHONE_NUMBERS;

should deliver what you need. Without more detail, your question cannot be answered adequately.

Answer 2

Try:
SELECT TOP 100 DISTINCT phone_number FROM numbers_table

where numbers_table is the table with the phone numbers and phone_number is the name of the phone number field.

Answer 3

select distinct numbers from table limit 100;
it will extract 100 numbers independent .. i mean not duplicates ..
good luck