How to get 3 weighted random data
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.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Vijaya KadiyalaPosted Oct 4, 2008, 4:42 PM
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