>>
>>/// More random :-)
>>
>>SELECT TOP 5 *
>>FROM YourTable
>>WHERE SomeCondition
>>ORDER BY NEWID()
>>
>
>What is the function NEWID()? Thank you.
This is SQL Server function. So, if you want to select top 5 random records in SQL Server, you use this variation.
If it's not broken, fix it until it is.
My Blog