Re: Limiting Rows Returned in Query
From: frank greene <fgreene_at_us.oracle.com>
Date: 1996/11/10
Message-ID: <565jv3$agd_at_inet-nntp-gw-1.us.oracle.com>#1/1
Date: 1996/11/10
Message-ID: <565jv3$agd_at_inet-nntp-gw-1.us.oracle.com>#1/1
You are lose. Thecorrect statement is something like
select variable_a, variable_b, last_variable
from your_table
where ROWNUM <= 100;
This will return the first one hundred rows. Rownum is a pseudo column that is available for any SQL retrieval. Received on Sun Nov 10 1996 - 00:00:00 CET