Re: only the first 10 rows
From: (wrong string) äth <matthias.spaeth_at_optimum-gmbh.de>
Date: Fri, 4 Jun 1999 13:31:08 +0200
Message-ID: <7j8d7h$56k$1_at_news.karlsruhe.punkt.de>
Date: Fri, 4 Jun 1999 13:31:08 +0200
Message-ID: <7j8d7h$56k$1_at_news.karlsruhe.punkt.de>
[Quoted] You can define a cursor for "SELECT * FROM <tabname>" and fetch only the first 10 rows.
Matthias
http://www.optimum-gmbh.de
[Quoted] 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
>...........................................................
Received on Fri Jun 04 1999 - 13:31:08 CEST