Subject Re: [firebird-support] Serial number in a query result
Author Jaison Joseph
>>> That trickiness appears in the FAQ: "How to get record number as part of
>>> dataset?"
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,