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.
Considering there is a table TblCustomer which contain columns CusomerId,CustomerName,Address.
what will be the query to retrieve customer randomly from a list.
Select top 1 * From TblCustomer Order by newId()
ReplyDeleteExpecting more from others....