I really appreciate if you can share the link with your friends via Facebook,twitter,blog etc.

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.