Oracle/SQL help

wicked · Post by **wicked** » Thu May 18, 2006 12:06 pm

Anyone familiar with writing SQL scripts? Is there anyway I can get a random sample from a script? Right now, I'm spooling a huge list, exporting to excel and doing it there. Takes forever to generate the list, so was wondering if SQL could do it for me.

Thanks!

Darkfire001 · Post by **Darkfire001** » Thu May 18, 2006 12:33 pm

When you say generate random sample, do you mean just pull some particular fields or a row out and generate it from that? There are a variety of ways, but an easy way would be just use "numrows" to find total rows, set that as the limit for a random number, and then pull a field based on the primary key. Thats a jiggy-rigged way to do it since if you have an incomplete dataset you'd have some issues, but thats the easiest method I can think of off the top of my head.

wicked · Post by **wicked** » Thu May 18, 2006 12:53 pm

I'm generating a huge list of ID numbers (thousands+) through a SQL script, of which I need to pull out 100 random ID's. I'm doing this for 6 different data sets. It's been spooling for about an hour now...LOL. I was hoping there was a way I could have sql pick 100 random ID's that meet set criteria w/o even generating the list (or so that I didn't have to see it and have it take hours). Make sense?

Thanks!

wicked · Post by **wicked** » Thu May 18, 2006 2:58 pm

nevermind, I found a way to limit my list another way ... thanks!

parno4u · Post by **parno4u** » Thu Dec 13, 2007 8:31 pm

ignotus · Post by **ignotus** » Fri Dec 14, 2007 3:46 am

parno4u wrote:bump

why?

blackjoke · Post by **blackjoke** » Fri Dec 14, 2007 9:05 pm

Out of curiosity did you limit your list length or find a way of getting a specific number of random selections?

wicked · Post by **wicked** » Fri Dec 14, 2007 9:40 pm

I really don't remember.

That was 1.5 years ago!