On Fri, 13 Mar 2015 11:58:19 +0000 (UTC), "Vishal Tiwari
vishualsoft@... [firebird-support]"
<firebird-support@yahoogroups.com> wrote:

> I have one question, any SQL I write, I would like to get auto-increment
> number (separate column obviously) to every row starting with 1. It is

just

> to numbering every record I get as an output of my sql. I do not want to
> use Generate which we do on table. This is just for SQL output I need.

With Firebird 3 you can use the ROW_NUMBER window function to do this.

Mark