Re: [sqlite] order of select result

On 13 Jul 2010, at 6:53am, Lloyd wrote: > I dont have any supportive column in table to issue "order > by". Can it be achieved by issuing an "ordr by" query on "row_id" (used by > sqlite internaly)? No consistently. Because unless you're using a rowid column you declared yourself, even the v

Re: [sqlite] order of select result

Hello L> Thanks Swithun. I dont have any supportive column in table to issue L> "order by". Can it be achieved by issuing an "ordr by" query on L> "row_id" (used by sqlite internaly)? You could, I think. But it might be better style to create an INTEGER PRIMARY KEY AUTOINCREMENT column to do t

Re: [sqlite] order of select result

Thanks Swithun. I dont have any supportive column in table to issue "order by". Can it be achieved by issuing an "ordr by" query on "row_id" (used by sqlite internaly)? Thanks, Lloyd > Hello > > L> Lets assume that we have a very simple without any indexing or > L>constraints. Now we have in

Re: [sqlite] order of select result

Hello L> Lets assume that we have a very simple without any indexing or L>constraints. Now we have inserted some data to the table. When we do a L>simple "select" query, is it guranteed that the rows will be retrieved L>in the same order as they are inserted? No. It may look like they are bein

[sqlite] order of select result

Hi, Lets assume that we have a very simple without any indexing or constraints. Now we have inserted some data to the table. When we do a simple "select" query, is it guranteed that the rows will be retrieved in the same order as they are inserted? Thanks a lot, Lloyd _