| Subject | Re: [firebird-support] SELECT FIRST [variable] |
|---|---|
| Author | Michael Weissenbacher |
| Post date | 2006-08-29T09:33:54Z |
Hi,
SELECT FIRST (:maxrows) key, value FROM table
Michael
>>Is it possible to use a variable to limit a number of returned records?I haven't tried it, but i guess you meant
> Yes.
>> FOR SELECT FIRST :maxrows key, value FROM table
> SELECT FIRST (:maxrows key), value FROM table
SELECT FIRST (:maxrows) key, value FROM table
Michael