random rows 2

[nyzja]

Hi! I have a view based on 3 tables. Now, out of the result, I need to randomly pick 5 ID's. I'm trying to use RAND but don't really know how to use it on the ID's or if it's even possible. Is there a way to randomly select an ID or a row from a view (or a temp table, whichever will work)?


Please help! Thanks!

 

[SQLSister]

Insert the data into a temp table which also has a uniqueidentifier field in it, populated using the newid function. Then sort on this field and pick the top 5 records. Look up newid for how to set up the table using newid().

Questions about posting. See faq183-874
Click here to help with Hurricane Relief

 

[SQLDenis]

select top 5 *
from YourView
Order by newid()

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[nyzja]

Thanks! It works!