On Tue, 17 Aug 2004, Keith Herold wrote: >The short question: do (temporary) VIEW's have rowid's in SQLITE? > >A small description of the problem: > > ... On occasion, the result is quite large, and my standard way >of returning results is very slow on large result sets, so I try to >break up how many results I return. Since TOP does not exist in sqlite, >I thought I would create a temporary view using the (Key,Value) pairs in >a SELECT statement.
BTW, TOP is not a standard SQL construct. The standard way to do TOP like functionality is to use LIMIT in your SELECT: http://www.sqlite.org/lang.html#select Notice the LIMIT keyword, just after the ORDER BY clause. > >--Keith > -- /"\ \ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL X - AGAINST MS ATTACHMENTS / \
