e.g. If you do:
SELECT c1 from t1 ORDER BY c2 LIMIT 5;
vs. just running the query without the "LIMIT" clause and taking the top 5 rows
Obviously in the case of a subquery this makes a difference:
select count(*) from (select * from t1 limit 5);
But would it ever in a straight query with joins etc.?
sqlite-users mailing list