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 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 being selected in the order they were > inserted. But there is no guarantee. So you should use an ORDER BY clause > to get the order you want. > > Swithun. ______________________________________ Scanned and protected by Email scanner _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users