Re: First

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Thu, 05 Aug 2004 05:51:06 GMT
Message-ID: <eVjQc.29477$T_6.3308@edtnps89>

Daniel Morgan wrote:

> Have to confess that I am really disappointed with the responses from
> Michel, Hans, Rene, and Turkbear because not one gave the answer I
> was going to give. And I was sure as I read through theirs that one or
> all of them would have done it first ... so here's mine:
>
> CREATE TABLE t AS
> SELECT object_name
> FROM all_objects
> WHERE rownum < 81;
>
> SELECT COUNT(*)
> FROM t;
>
> SELECT *
> FROM t
> SAMPLE (25);
>
> Returns 25% of the rows.
>

Sure .... but which is 'first'? <g>

/H Received on Thu Aug 05 2004 - 00:51:06 CDT