I have a table called test and it has about 50 columns ( about 200 bytes of data, all columns combined). I need to browse the entire table periodically. I have a primary key PK1 which basically is a increasing sequence number.
SELECT * from test WHERE PK1>100 AND PK1<200; SELECT * from test WHERE PK1>100 LIMIT 100; Will the above queries have the same effect? Or will LIMIT behave differently, i.e. get the entire result set and then return the first 100 from it? I delete records in my table (it is like a queue implementation) so I might have gaps in between which is why I want to use the LIMIT clause. Any advice would be greatly appreciated. -- View this message in context: http://old.nabble.com/SQLITE-LIMIT-clause-tp32607006p32607006.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
