limiting row return by count

mznvz8 · #1 (**permalink**) 01-15-04, 17:34

Does Informix have a function similar to Oracle's "rownum" command to limit the number of rows returned on a query?

Oracle example: select * from test_tbl where rownum < 10;

lloydnwo · #2 (**permalink**) 01-15-04, 22:04

Quote:

Originally posted by mznvz8
Does Informix have a function similar to Oracle's "rownum" command to limit the number of rows returned on a query?

Oracle example: select * from test_tbl where rownum < 10;

Hi there,

you can use "rowid" in informix.

Regards,

lloyd

vpshriyan · #3 (**permalink**) 01-16-04, 03:55

Hi,

You may also use FIRST keyword to to limit the number of rows returned in a query.

example:
select first 5 * from test_tbl ;

Regards,
Shriyan

Nicjordan · #4 (**permalink**) 01-16-04, 06:13

Quote:

Originally posted by vpshriyan
Hi,

You may also use FIRST keyword to to limit the number of rows returned in a query.

example:
select first 5 * from test_tbl ;

Regards,
Shriyan

My 2c

This first 5 method is much better - on one of my tables the rowid starts at 259 - so 'where rowid < 6' does not return anything, but 'first 5' gives 5 returns.

Internet Services

Web Development

Digital Marketing

Consumer Tech