try
select first 100 skip 0 fieldname from table, if you want to select the first
100 rows

hope it helps,
regina

On Tuesday 16 September 2003 14:32, Datatal AB - Gauffin, Jonas wrote:
> Hello
>
> In mssql u can write
> select top fieldname from table where x=y order by fieldname desc
>
> is there something like that in firebird?
>
> Thanks,
> Jonas
>
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/