we need to select the top records randomly to show in the front page.
for example, you can see in the facebook. It will show the 5 of friends in the list.
If you refresh the page it will show another set of users.
In order to get the top 5 records randomly we need to use the following query
SELECT TOP 3 * FROM Products ORDER BY NEWID()
|
The output will be like the following.
When you execute again then you will get the another set of different records for the same query.