SQL PHP HTML ASP JavaScript articles and free scripts to download
ASP > Select Record

Random record from table in MSSQL database

We can get random records from MSSQL tables by using TOP and NEWID() functions. Here is the SQL to get one random record each time the query is executed.

select top 1 * from member order by NEWID()

To get more than one ( say 3 ) records here is the query.

select top 3 * from member order by NEWID()

Be the first to post comment on this article :


Post Comment This is for short comments only. Use the forum for more discussions.
Email( not to be displayed)Privacy Policy
1+2=This is to prevent automatic submission by spammers. Please enter the result of the sum as asked

HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us

©2000-2015 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer