Re: only the first 10 rows

From: <armaghan_at_usa.net>
Date: Fri, 04 Jun 1999 12:53:00 GMT
Message-ID: <7j8i77$c03$1_at_nnrp1.deja.com>


Another simple way which I use in my Oracle Link utility for Table Quick View is:

SELECT sale_id, sale_amount FROM cust_sales WHERE rownum <= 10 ORDER BY sale_amount

Best regards,
M. Armaghan Saqib (armaghan_at_geocities.com) Oracle Link for MS Excel. A free tool for Oracle->MS Excel http://www.geocities.com/WallStreet/Floor/8484/

In article <7j8d7h$56k$1_at_news.karlsruhe.punkt.de>,   "Matthias Späth" <matthias.spaeth_at_optimum-gmbh.de> wrote:
> You can define a cursor for "SELECT * FROM <tabname>" and fetch only
the
> first 10 rows.
>
> Matthias
> http://www.optimum-gmbh.de
>
> Amir Zawar schrieb in Nachricht <37578FB0.34B8F4ED_at_desy.de>...
> >Hello all.
> >I've a SQL problem.
> >I have a table with abaut 20000 rows.
> >But I want to get only the first 10 rows from this table (Top 10).
> >How could I solved this problem ?
> >(select * from tablename ....?)
> >
> >Amir
> >
> >
> > Amir Zawar, Deutsches Elektronen-Synchrotron DESY
> >...........................................................
> > EMail: amir.zawar_at_desy.de
> > Webserver: http://www.desy.de
> >...........................................................
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jun 04 1999 - 14:53:00 CEST

Original text of this message