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
