By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,650 Members | 812 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,650 IT Pros & Developers. It's quick & easy.

Randomly Choose One Million Rows

P: 1
I have a database that is around 12 million rows. I need to choose 1 million of them randomly and change the value of one of the fields. There is no oids on the table and no serial. Is there any way I can accomplish this without the lengthy 'random()' function?
Jun 20 '12 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,364
If you want something random, you have to use random().
Jun 20 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.