I'd like to have a query that returns the number of the record as a column in the record set, e.g. something like
SELECT <count of current Row> , * from <My Table> where <whatever>
so that the results are
1 <column> <column> etc
2 <column> <column> etc
3 <column> <column> etc
4 <column> <column> etc
Note that the counter I need is for the returned set, not the identity col or equivalent RowID of the underlying table.
As I recall there was some trick to do this by creating a table of integers, but I forget what it is.