-----------------------------------------------------------------
SQL RANDOM LIST OF PRODUCTS
Select Top 10 *
from
(
Select ProductID, ProductName, UnitPrice
from Products
--Where
-- ForumQuestion.QuestionTitle Like @SearchKeyword
) MyTable
ORDER BY NEWID()
Sunday, April 24, 2011
SQL Random List Of Records
Labels: SQL Utility Snippets
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment