Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: only the first 10 rows

Re: only the first 10 rows

From: Rose Noel Kamene <rkamene_at_easynet.co.uk>
Date: Sun, 6 Jun 1999 10:52:52 +0100
Message-ID: <7jdgo9$1i35$1@quince.news.easynet.net>


On what criteria is the selection of the 10 rows to be based on? RNK. Amir Zawar <amir.zawar_at_desy.de> wrote in message news:37578FF6.A3346D00_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
>...........................................................
Received on Sun Jun 06 1999 - 04:52:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US