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
 SQL Server Development (2000)
 Returning one random record from a table

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-08-24 : 20:12:03
Dan writes "I read the post 'Returning Rows in Random Order' and I have a similar requirement, but I only need one 'random' row from the table. Is there an easier way to accomplish this, or should I just take the first row from the sample that I read?"
   

- Advertisement -