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
 Other Forums
 MS Access
 Random Numbers

Author  Topic 

danasegarane76
Posting Yak Master

242 Posts

Posted - 2007-09-06 : 08:28:49
Hi all,
I am having one table with id from 1 to 50. Now I want to return random records from that table using rnd.The point is that is there any fucntion like

[code]
Select [id] from tblids where id not in (values) with rnd
[code]

Thanks in Advance
Dana

danasegarane76
Posting Yak Master

242 Posts

Posted - 2007-09-07 : 01:48:07
Or Suggest any other Method

Dana
Go to Top of Page
   

- Advertisement -