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.
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.
Does it mean records are ordered after group them as using order by?
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
