Path: utzoo!utgpu!watserv1!watmath!att!rutgers!usc!srhqla!unigold!lance
From: lance@unigold.UUCP (Lance Ellinghouse)
Newsgroups: comp.databases
Subject: SELECT only x number of items
Keywords: SELECT SQL
Message-ID: <5@unigold.UUCP>
Date: 17 Oct 90 22:53:59 GMT
Organization: UNIGOLD, Encino, Ca
Lines: 15

Is there a way to say 'I want to select only the first 5 items
that full-fill my criteria?' without using ESQLC? I would like
to really do it using straight SQL (BTW: I am using Ingres and
Ingres specific ways are fine also).

Thanks in advance.

+----------------------------------------------+------------------------------+
|Lance Ellinghouse                             |Any ideas on what to put here?|
|E-mail: lance@unigold.uucp                    |I have no idea... :)          |
|        lance@unigold.sr.com                  |                              |
|        unigold!lance@srhqla.sr.com           |                              |
|        hermix!unigold!lance@anes.ucla.edu    +------------------------------+
|USnail Mail: UNIGOLD, 16311 Ventura Blvd. Suite 1100, Encino, Ca, 91436      |
+-----------------------------------------------------------------------------+