17/02/2010

Return Random Values From SQL

If you want to retun random values from your table in SQL Server, Use the following query:

SELECT top 4 * FROM dbo.authors
ORDER BY NEWID()

No comments:

Post a Comment