On 18 Nov 2003 at 8:38, Uwe Oeder wrote:

>How can I tell firebird to return only a set amount of records ?
>SELECT * FROM People ; Returns 70000 records but I want to return only the
>first 100 ?

IMHO, returning first 100 has the same meaning as returning 70000
and the same meaning as returning nothing. I know, it is common
design when newly-opened grid is filled by some data (just in order
not to be empty) but it is wrong design for true client-server
applications.
Narrow your query by using well-formed WHERE clause.

SY, Dimitry Sibiryakov.