select a RANDOM distinct row 
Author Message
 select a RANDOM distinct row


I have a simple table from which I need to randomly select one single row.

I can't find any documentation on the rand() function (including the SQL Server docs) and I would
appreciate any help on how to use this function to accomplish the random selection.

Thanks in advance...


Impact Computer Systems

Thu, 04 Nov 1999 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. Selecting 1 random row from each of n random groups

2. Random select one row from a cursor?

3. Selecting a random row

4. Selecting a random row

5. Select random rows

6. Selecting a random set of rows

7. SELECT random rows for audit purposes

8. Select random rows?

9. Selecting random rows from multiple ranges

10. Selecting random row set

11. Selecting random rows

12. Selecting random row

Powered by phpBB® Forum Software