Re: Random selection of data throug SQL querry

From: Praful Thakkar <thakkar_praful_at_yahoo.com>
Date: Mon, 18 Dec 2000 06:15:01 -0800 (PST)
Message-Id: <10714.124833@fatcity.com>

Try this ...

select field_list from tablename sample(1);

This will give you a random sample of about 1% of total recs in your table.
(It's Oracle 8.1.6 - I'm not sure if it would work for earlier versions.)

HTH.

• Praful
  • Shakeel Qureshi <msklq_at_yahoo.com> wrote:
    > Hi all!
    >
    > I immediate need your help.
    >
    > How could I random select few lines from a large
    > table through an sql select statement.
    >
    > Appreciate quick response.
    >
    > Shakeel Qureshi
    > squreshi_at_barpoint.com
    >
    >
    > __________________________________________________
    > Do You Yahoo!?
    > Yahoo! Shopping - Thousands of Stores. Millions of Products.
    > http://shopping.yahoo.com/
    > --
    > Please see the official ORACLE-L FAQ: http://www.orafaq.com
    > --
    > Author: Shakeel Qureshi
    > INET: msklq_at_yahoo.com
    >
    > Fat City Network Services -- (858) 538-5051 FAX: (858)
    > 538-5051
    > San Diego, California -- Public Internet access /
    > Mailing Lists
    >
    

    ---

    
    > To REMOVE yourself from this mailing list, send an E-Mail
    > message
    > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
    > and in
    > the message BODY, include a line containing: UNSUB ORACLE-L
    > (or the name of mailing list you want to be removed from).
    > You may
    > also send the HELP command for other information (like
    subscribing).

    ---

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. Received on Mon Dec 18 2000 - 08:15:01 CST