Friday, June 17, 2011

SQL Random List Of Records


Select Top 10 *
from
(
Select ProductID, ProductName, UnitPrice
from Products
--Where
-- ForumQuestion.QuestionTitle Like @SearchKeyword
) MyTable

ORDER BY NEWID()

0 comments:

Post a Comment

Twitter Delicious Facebook Digg Stumbleupon Favorites More