Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 5 of 5 total

How do I duplicate the Row_Count feature found elsewhere

Thu, Jan 16 2014 4:46 AM	Permanent Link
Sean McDermott	I query a data set of dates and want to rank them by date so no issue there. It would be nice to have a row number appear with the results. Can't remember how I did it before. Thanks, Sean
Fri, Jan 17 2014 3:03 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Sean, << I query a data set of dates and want to rank them by date so no issue there. It would be nice to have a row number appear with the results. Can't remember how I did it before. >> Do you want the row number of the row as it appears in the result set, or the row number from the original table ? Tim Young Elevate Software www.elevatesoft.com
Sat, Jan 18 2014 5:32 AM	Permanent Link
Sean McDermott	Hi Tim, the result set is what. The line numbers would be sequential from first to end of list 1,2,3,4,5.......25 or whatever, thanks "Tim Young [Elevate Software]" wrote: Sean, << I query a data set of dates and want to rank them by date so no issue there. It would be nice to have a row number appear with the results. Can't remember how I did it before. >> Do you want the row number of the row as it appears in the result set, or the row number from the original table ? Tim Young Elevate Software www.elevatesoft.com
Wed, Jan 22 2014 5:35 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Sean, << Hi Tim, the result set is what. The line numbers would be sequential from first to end of list 1,2,3,4,5.......25 or whatever, thanks >> Then you want the RUNSUM() aggregate function. Just do the grouping in a way that uniquely identifies each result set record, and use: SELECT RUNSUM(1), etc. FROM MyTable GROUP BY x,x,x Tim Young Elevate Software www.elevatesoft.com
Thu, Jan 23 2014 11:35 PM	Permanent Link
Sean McDermott	Thanks Tim "Tim Young [Elevate Software]" wrote: Sean, << Hi Tim, the result set is what. The line numbers would be sequential from first to end of list 1,2,3,4,5.......25 or whatever, thanks >> Then you want the RUNSUM() aggregate function. Just do the grouping in a way that uniquely identifies each result set record, and use: SELECT RUNSUM(1), etc. FROM MyTable GROUP BY x,x,x Tim Young Elevate Software www.elevatesoft.com