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
