How to display result row number in SQLite?
I have my select statement returning requested values, but how can I add a column displaying row numbers. for example 1,2,3... etc.
Asked
Active
Viewed 128 times
0
-
Probably best done in code when fetching the results. It can be done, but not without (un-necessarily?) complicating your SQL. – Joachim Isaksson Jan 02 '14 at 19:03
-
Why can't you just count the number of records returned so far? – CL. Jan 02 '14 at 20:38