>>> That trickiness appears in the FAQ: "How to get record number as part of
>>> dataset?" http://www.firebirdfaq.org/faq343/
>>>

The above solution does not have any side effects, am I right?

>>> 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.

(Actually, i only checked the first solution, ie from the faq)

> Needless to say, if the generator/sequence is used by multiple users,
> then this isn't safe.

Thank you very much,

Jaison.