> 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