Limited resultset with Informix

[torrud]

Hi,

I am looking for a possibility to limit the result set of a SELECT statement. I am using an Informix database. Is there a builtin way to get only the first 100 results of a query like it is possible on a MySQL database? There I could write

SELECT * FROM persons ORDER BY name LIMIT 100;


How do I solve this with an Informix DB?

Thanks in advance.

[torrud]

Well, I found the solution

SELECT FIRST 10 * FROM persons ORDER BY name;