|Subject||Re: [firebird-support] How To Generate Auto Increment Number in SQL Itself ?|
On Fri, 13 Mar 2015 11:58:19 +0000 (UTC), "Vishal Tiwari
> I have one question, any SQL I write, I would like to get auto-incrementjust
> 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 toWith Firebird 3 you can use the ROW_NUMBER window function to do this.
> use Generate which we do on table. This is just for SQL output I need.