Hi,

> That trickiness appears in the FAQ: "How to get record number as part of
> dataset?" http://www.firebirdfaq.org/faq343/
>
> A throw-away SEQUENCE would also do the trick, I think:
>
> sql> create sequence AdHoc;
> sql> select next value for AdHoc as SrNo, d.* FROM (...) d;
>
> -Mike
>
>

This is exactly what I want.

Thanks to all who responded.

Jaison Joseph.