Path: utzoo!attcan!uunet!wuarchive!emory!hubcap!ncrcae!ncr-sd!iss-rb!adt!benl
From: benl@adt.SanDiego.NCR.COM (Ben.Lheureux)
Newsgroups: comp.databases
Subject: Re: SELECT only x number of items
Keywords: SELECT SQL
Message-ID: <787@iss-rb.SanDiego.NCR.COM>
Date: 20 Oct 90 19:58:45 GMT
References: <5@unigold.UUCP> <2796@ns-mx.uiowa.edu> <1860@hulda.erbe.se>
Sender: news@iss-rb.SanDiego.NCR.COM
Reply-To: benl@adt.SanDiego.NCR.COM (Ben.Lheureux)
Organization: NCR Corporation, Rancho Bernardo
Lines: 19

In article <1860@hulda.erbe.se> prc@erbe.se (Robert Claeson) writes:
>In a recent article broy@vaxa.weeg.uiowa.edu writes:

>>Perhaps Ingres can use the ROWNUM pseudo-column that Oracle uses?
>>Select * from table_name where rownum < 6;
>>Note that rownum is assigned before the rows are ordered by any 
>>ORDER BY clause.

>In Ingres, retreiving a limited number of rows is doable with,
>among others, database procedures.

Would you provide an example of how to do this with, and without 
database procedures?


Benoit.Lheureux@sandiego.NCR.COM      ####################################
Application Dev Tools, Dept 4775      #  Opinions are my own, not NCR's  #
16550 West Bernardo Drive             #    Farewell Micro C Magazine     #
San Diego, CA 92127 619/485-3578      ####################################