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 :