This would not be something you would sort by. It should be assigned a
value only during final 'display' of the query after all 'sorts' of
operations are done with.
-----Original Message-----
From: Alex Bowden
Sent: Monday, July 01, 2013 12:46 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Is there a way to return the row number? (NOT
therowid)
I can't wait to try
order by row_number desc
On 1 Jul 2013, at 10:33, Tony Papadimitriou <to...@acm.org> wrote:
Is there a function (or method), e.g., row(), to return the sequence
number of the selected row? This is not the same as ROWID. row() should
give a sequence number always starting from 1 up the to the number of rows
returned by the view/select etc.
If not, then please add to the wish list.
TIA
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
