Try "order by code.rowid" I think that will do what you want and fits in with what sqlite3's behavior should be.
As long as you don't delete rows you'll be OK. http://www.sqlite.org/autoinc.html Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Sintoni Stefano (GMAIL) [stefano.sintoni.cnigr...@gmail.com] Sent: Friday, July 22, 2011 8:54 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Strange result using JOIN I don't have other column good for use the SELECT. Now I don't have good columns to use the SELECT, now I'm afraid my only solution is to create a new column with a value of the order generated by my application. Stefano On 07/22/2011 03:45 PM, Simon Slavin wrote: > On 22 Jul 2011, at 2:37pm, Sintoni Stefano (GMAIL) wrote: > >> In any case how I can take the result I need ? I not have other column >> right for made one ORDER BY and I need to respect the sequence or CODE >> table like >> >> The table CODE. >> CODE;VALUE; >> 61311;18462F; >> 61311;18461F; > SQL has no concept of the order of rows in a TABLE. A TABLE is a collection > of rows in no particular order. You could issue three SELECT commands one > after the other and they could return the rows in three different orders and > that is perfectly acceptable given the SQL standard. > > When you want the results of a SELECT to appear in a particular order you > specify that using an 'ORDER BY' clause for your SELECT statement. > > What controls the order you want to see on your output ? Is it always > descending order of the VALUE column ? Is it the order you put the data in > in ? Something else ? > > Simon. > _______________________________________________ > 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
