Home Forums SQL Server 7,2000 General How to get certain number of random records RE: How to get certain number of random records
mccork
SSC-Insane
Points: 22288
More actions
August 17, 2003 at 5:29 pm
#470216
I sometimes use NEWID() to "randomise" results. Eg.
select top 4 * from pubs.dbo.authors
order by newid()
Cheers,
- Mark
Cheers,- Mark