Problem: Many of the developers write complex and huge code to return random images or news on every page refresh on its website or project.
Solution: Sql server provides easy way to return random result on each call.
Query:
Select * from [table1] order by newid()
Result:
if you have 2 records in your table you will get different result each time.
1 comment:
this is a great and simple way to get unique result each time...
Post a Comment