Did you mean to order by name in both the inside and outside? Or did you mean "order by id desc" for the inner part? If so you can always do that on the outside, which as mentioned is the only one that counts in the end.
select row_number(name) as id, name from example order by name asc, id desc; -----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of dspub...@freemail.hu Sent: Thursday, January 26, 2017 11:24 AM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] application function value in sql where Thanks for responses, I have an other problem select * from (select row_number(name) as id,name from example order by name desc) t order by name In this query, the server why doesn't use the nested "order by"? I want to numbering the inner data descending, but I can't, because looks like, the server ignores it. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users