Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Random Results

Author  Topic 

rme8494
Yak Posting Veteran

98 Posts

Posted - 2002-06-10 : 12:01:16
We have a customer database and use the customers phone number as the primary key. I would like to randomly pull 10 phone numbers from the DB for a drawing. How can I randomly return 10 rows?

Ryan


Ryan Everhart
SBC Ameritech

macka
Posting Yak Master

162 Posts

Posted - 2002-06-10 : 12:09:38
The FAQ covers this - have a look at this for starters:

http://www.sqlteam.com/FilterTopics.asp?TopicID=135

macka.

Go to Top of Page
   

- Advertisement -