How to get 3 weighted random data

Question

How can i get 3 different weighted random data from database. Weighted random means i have a column which keeps the weight of the datas. So weight affects the random.

Vijaya Kadiyala · Answer

Hi Are you looking for random set of records from your database tables? If YES then then you can use RAND() or NEWID() or TOP functions to select. If NO then could you please paste some sample data. Thanks -- Vj http://dotnetvj.blogspot.com http://oravj.blogspot.com