Sponsored By
MindStick SurveyManager
Advertise with Us
Advertisement
Advertise with Us
Follow Us
Follow _MindStick_ on Twitter View MindStick Software's LinkedIn profile View MindStick Software's Facebook profile
Mindstick
Article Article  Forum Forum  Blog Blog  Quiz Quiz  Beginner Beginner  Careers Careers  Contact Contact  Login Login  
Home | Product | Services | About Us | Interview | DeveloperSection | Submit an Article | Submit Blog
Report Abuse Form
Reason:    
   
Home >> Database >> MSSQL Server 2000/2005/2008/2012 >> How to selecte random records from SQL Server table?
Author Post

Tanuj Kumar

Total Post: 43
Member Since: 3/20/2012
Points: 217
How to selecte random records from SQL Server table?
Posted On: 3/24/2012 1:48:00 AM
Hello Everyone,
I want to select records randomly from my SQL Server table. Could you explain it with the code that how to do it?

Thanks in advance!!
Author Post

Arun Singh

Total Post: 48
Member Since: 7/1/2011
Points: 331
Re: How to selecte random records from SQL Server table?
Posted On: 3/26/2012 1:19:45 AM
Hi Tanuj Kumar,
In SQL Server database, there is a function NEWID() through which we can select SQL table record randomly.
Query: select * from tbl_Name order by newid()
I hope it might be resolve your problem.
Report Abuse Form
Reason:    
 
Total Online Users: 3783
Advertisement
MindStick DataConverter
Advertise with Us
  
Copyright © 2009 - 2013MindStick. All Rights Reserved.