Sunday, July 24, 2011

How to select random data from database


Suppose you have to get the random data from the database, you can use sql query which get random records or data from the database. Every time it show the random records or data

Here is the sql query  to get random  records:

Syntax: " SELECT  TOP Clause F FROM  Table_Nameable_Name ORDER BY NEWID()"

E.g:     "SELECT top 4 Image from tbl_OfficeWorkers ORDER BY NEWID()"

No comments:

Post a Comment