Subject Re: [firebird-support] How To Generate Auto Increment Number in SQL Itself ?
Author Ann Harrison

On Mar 13, 2015, at 8:45 AM, Vishal Tiwari vishualsoft@... [firebird-support] <> wrote:

I have EmpCode column in my SQL

Say for example, my sql returns total 100 records in that it returns 10 records for every employee. Here I would I display Row_Number as 1 for first 10 records i.e. for first employee, then for next 10 records i.e. for second employee Row_Number as 2, and so on. So finally Row_Number value should endup with 10.

How about a second context variable for the EmpCode and reset the row_number iff the EmpCode changes?  Or, if you'd rather number each row for an employee differently and start again at 1 for the next employee, increment the row_number unless EmpCode changes then reset to 1.

Sigh.  SQL used to be such a simple ugly stupid language....   Am I the only one who finds this sort of magic unreadable?