> Thanks for your reply.
>
> Could you give me an example how to use clauses FIRST, SKIP or ROW TO?

Thanks to the efforts of Paul Vinkenoog et al., this is well documented. ;-)

FIRST / SKIP:
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-select.html#langrefupd25-first-skip

ROWS:
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-select.html#langrefupd25-select-rows


--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/

> Thanks and regards,
> Sugiarto
>
> --- In firebird-support@yahoogroups.com, W O<sistemas2000profesional@...> wrote:
>>
>> Of course, you can to use clauses FIRST, SKIP or ROW TO
>>
>> Additionally, you can use a WHERE clause.
>>
>> Greetings.
>>
>> Walter.
>>
>>
>>
>> On Thu, Jan 19, 2012 at 11:46 PM, trskopo<trskopo@...> wrote:
>>
>>> **
>>>
>>>
>>> Hi all,
>>>
>>> Suppose I have a sql statement :
>>> select * from table
>>>
>>> Is that possible to return only a few rows from that statement (not the
>>> whole result), just like MySQL?
>>>
>>> Thanks and regards,
>>> Sugiarto
>>>
>>>
>>>
>>
>>
>> [Non-text portions of this message have been removed]
>>
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>