Subject Re: [firebird-support] How To Generate Auto Increment Number in SQL Itself ?
Author Mark Rotteveel
On Fri, 13 Mar 2015 11:58:19 +0000 (UTC), "Vishal Tiwari
vishualsoft@... [firebird-support]"
<> 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
> 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.