Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
A Jamwal — — source: Informix-list mailing list archive (1991-1998)
Hi everyone,
Is it possible to limit the number of rows
returned by a SELECT statement? For example:
SELECT * FROM items
The above statement returns all the rows from the
items table. However, I want to select only, say,
the first 20 rows. How do I restrict the number of
rows SELECTed? In Oracle, one can use rowsnum like:
SELECT * FROM items
WHERE rownum < 21
Is there something similar in Informix?
Thanks in advance.
Jamwal.
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.