For training related to .net,OOPS,design patterns, MVC,WCF and .net fundamentals
contact at sukeshmarla@gmail.com or Click Here

10 November 2011

Retrieving row randomly

ABC organization decides, they will randomly choose one of there customer each day and send some special gift to there address.
Considering there is a table TblCustomer which contain columns CusomerId,CustomerName,Address.
what will  be the query to retrieve  customer randomly from a list.