Re: Random rows

2017-03-28 Thread Steve Terrell
50 rows from a table containing 1,000 rows. It will only be approximate. The ".0" is added to make sure the division does not yield an int. You can replace the division with any ratio you like. Anyway, after doing the above upsert select, I can query for the random rows like th

Random rows

2017-03-28 Thread Mike Prendergast
Any suggestion on how I could obtain a random set of rows in Phoenix? I'm looking to get a sample set spread across all regions for testing purposes. Thanks in advance Michael Prendergast *iota IT* Vice President / Software Engineer (cell) 703.594.1053 (office) 571.386.4682 (fax)