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