Re: First

Peter Plumber wrote:

> Hi,
>
> Does Qracle 9i support a SELECT that returns
> only a subset of the records
>
> something link
>
> SELECT FIRST 1 * FROM tablename
>
> thx
>
> Peter

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.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)