sql server numbers table
how to select 100 differents rows in ms sql server?
I have a table with almost 50,000 telephone numbers. I need to select 100 different telephone numbers ... any help ??
Thank you.
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.
[phpbay]sql server numbers table, 30, "11211"[/phpbay]
[phpzon]sql server numbers table, 5, Electronics[/phpzon]
Asp.Net 2.0 & C# Photo gallery with upload (part 1)