Re: Selecting a random sample of data using PL/SQL

From: Mike Ziemann East Su <esha1_at_cix.compulink.co.uk>
Date: 1996/06/27
Message-ID: <Dto0Fx.33L_at_cix.compulink.co.uk>#1/1

There is a random function in a package someone has posted here before, but when I have wanted to get a sample of data I just decided to take 1 in every X samples, so if you want 10000 from 2,000,000 take 1 in every 200, the easiest way to do this is to use the mod function eg where mod(N,200)=0 where N is a counter variable.

Mike Ziemann Received on Thu Jun 27 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: an133911_at_anon.penet.fi: "Re: Differences between the Microsoft and the Oracle SQL server"
Previous message: Kurtis D. Rader: "Re: Raw Devices: Increased Performance?"
Maybe in reply to: Beverley Williams: "Re: Selecting a random sample of data using PL/SQL"
Next in thread: an133911_at_anon.penet.fi: "Re: Differences between the Microsoft and the Oracle SQL server"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message