Thanks a lot. It solved my problem.

Thanks.
--- In firebird-support@yahoogroups.com, "Thomas Steinmaurer"
<ts@i...> wrote:

> > when I am executing following query
> >
> > "select top 1 ID as FSID from Employee"
> >
> > I am getting an error "Token unknown 1"
> >
> > Does firebird support "top" or not. If not then what is the
> > alternative.
>
> Use FIRST (in conjunction with an ORDER BY ASC).
>
> For example:
>
> select first 1 ID as FSID from Employee
> order by ID;
>
>
> --
> Best Regards,
> Thomas Steinmaurer
>
> The IB LogManager Product Family
> Logging/Auditing Suite for InterBase and Firebird
> http://www.iblogmanager.com