cricketfan <srtedul...@yahoo.co.in> wrote: > SELECT * FROM test WHERE PK1 > 100 LIMIT 100 ORDER BY PK1 ASC; > > Since I have the index on PK1, I believe the rows will be returned in the > ORDER of PK1. Putting an ORDER BY clause will be a no-op.
Probably, but that's an implementation detail. If you rely on a particular property of a resultset, it's best to request it explicitly, rather than hoping that the implementation just happens to tilt your way. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users