Check our online training feedbacks 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.


1 comment :

  1. Select top 1 * From TblCustomer Order by newId()

    Expecting more from others....

    ReplyDelete

Your comments, Feedbacks and Suggestions are very much valuable to me :)