ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: vivianteoh on October 22, 2019, 01:43:30 pm

Title: Feature similar to ROW_NUMBER() from SQL?
Post by: vivianteoh on October 22, 2019, 01:43:30 pm

Hi. May I know whether PQGrid able to generate sequential number within each group?

Example
Department: A
1  xxxx
2  xxx
Department: B
1  xxxxxx
2  xxxxx
3  xxxxx

If yes, may I know whether the row number can be exported to Excel?

Title: Re: Feature similar to ROW_NUMBER() from SQL?
Post by: paramvir on October 23, 2019, 01:25:24 pm

Sorry, I don't see any way to generate sequential numbers as per your requirement. I would let you know if I find one.

Title: Re: Feature similar to ROW_NUMBER() from SQL?
Post by: vivianteoh on October 24, 2019, 08:22:29 am

Sure! Thanks  ;)