Firebird supports FIRST, not TOP. Otherwise identical to what you wrote.

Set

At 10:40 02.07.2003 +0000, you wrote:

>Hi,
>
>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.
>
>Thanx in advance.
>
>Cheers,
>Ghanshyam