How to select random records in SQl Server

No.of Views	:	1283
Bookmarked	:	0 times
Downloads	:
Votes	:	0

By RRaveen On 15 Feb 2010 22:02:47

Tag : Sql Servers , T-SQL

Skill Level: Intermediate

Images in this article missing? We recently lost them in a site migration. We're working to restore these as you read this. Should you need an image in an emergency, please contact us at info@codegain.com

Hi Guys,

Most of the developers, asking in forums how to select random records from the database in Sql Server.

Here script:

SELECT TOP 5 employeeID, FName,LName from Employee
ORDER BY NEWID();

Thank you
RRaveen
Keep looking

About Author

RRaveen

Occupation	-	Software Engineer
Company	-	TGS
Member Type	-	Gold
Location	-	Singapore
Joined date	-	03 Jun 2009
Home Page	-	codegain.com
Blog Page	-	www.codegain.com

- B.Sc. degree in Computer Science. - 4+ years experience in Visual C#.net and VB.net - Obsessed in OOP style design and programming. - Designing and developing Network security tools. - Designing and developing a client/server application for sharing files among users in a way other than FTP protocol. - Designing and implementing GSM gateway applications and bulk messaging. - Windows Mobile and Symbian Programming - Having knowledge with ERP solutions


Other popularSectionarticles
How to use Partition Analytical Function in SQL How to use Partition Analytical Function in SQL Published Date : 15/Feb/2010 Use of Rank() function in SQL Server Use of Rank() function in SQL Server Published Date : 15/Feb/2010 Use of Dense_Rank() function in SQL Server Use of Dense_Rank() function in SQL Server Published Date : 15/Feb/2010 How to Get First,Last and No of Days in Month Using T-Sql I have read few questions in forums, about how to select first, last date month and how many days in a month. In my project had used some query to perform these tasks. I will share those with article. Published Date : 17/Dec/2010 how to get how many records entered in day by a user in sql server. how to get how many records entered in day by a user in sql server. Published Date : 15/Feb/2010

Comments

By:Doug	Date Of Posted:6/3/2011 12:13:15 PM
Thank you
I'm not sure if I ever would have figured this out. without using location.host i was getting repeated "Permission Denied" and "Object Expected" errors. This fix did away with them all.

By:E.	Date Of Posted:12/17/2010 6:12:20 AM
Super
wow this really helped me out! Thanks a lot.