|Subject||RE: [firebird-support] "select top 1 ID as FSID from Employee" not supported|
> when I am executing following queryUse FIRST (in conjunction with an ORDER BY ASC).
> "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
select first 1 ID as FSID from Employee
order by ID;
The IB LogManager Product Family
Logging/Auditing Suite for InterBase and Firebird