Wenton Thomas wrote: > Does the following sql statement produce same result? > (1)select a,b from tbl group by a ordr by a . > (2)select a,b from tbl group by a.
They might by accident, but it's not guaranteed. > In the sqlite website, it says if there is not exist a > Transient Indices > for group by or order by, sqlite will create the > > Transient Indices > as a first step. > > so group by and order by are processed in same manner. This is an implementation detail subject to change without notice. It would be unwise to rely on it. If you need your records ordered, why not add an ORDER BY clause stating that explicitly? Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
