Randon 5 records - SQL Server Forums

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)

Randon 5 records

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-08-13 : 08:06:10

NILESH writes "I want to select random 8 records from the database.
i used rand() function but how can i get the exact count.
is there any parameter for this.

Regards,
NILESH"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-08-13 : 08:04:33

Did you read the SQL Team FAQ:

http://www.sqlteam.com/FAQ.asp

I'm guessing......no.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources