Re: SQL info

From: Mats Larsson <matlar_at_rsv.svskt.se>
Date: 1995/09/01
Message-ID: <1995Sep1.082801.11866_at_rsv.svskt.se>#1/1

In article <41l0h0$fs3_at_titan.ci.ua.pt>, ana_at_news.ci.ua.pt (Ana Maria Santos) says:
>
>
>Hello,
>
> is it possible to limit the number of rows (ocurrences) returned
>from a query?
>
>like:
> select * from table; -> gives 1000 ocorrences and I only want the
> first 50.
>
>
>Bye,
>Ana

Try with :

      select * from table where rownum < 51;

Unfortenately

      select * from table where rownum < 51
       order by "some-column"
       ;

will retrieve thae same lines as above as the lines are numbered before ordering.

Mats Larsson          |  Tel:   +46 8 7647921
RSV DataService       |  Fax:   +46 8 983146
171 94 Solna, Sweden  |  Email: matlar_at_rsv.svskt.se

Received on Fri Sep 01 1995 - 00:00:00 CEST