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.?

- Deon

sqlite-users mailing list

Reply via email to