--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:

>
> >
> > Can i do with firebird 1,5,2
> >
> >
> >
> > select id
> > from (select first 5 id from mytable order by 1 desc)
> > order by 1 desc
>
> Have you tried? :-)

No. It would not surprise me if it doesn't like the internal order by,
the internal first n, or the ordinal position. As all of my customers
are running some version of 1.5, I can not use FB 2 specific features.
You should refer to the release notes for the exact syntax.

Adam