Hello, Is it the "LIMIT" clause you need? If so, did you check the syntax page?
http://sqlite.org/lang_select.html [LIMIT integer [( OFFSET | , ) integer]] For example, SELECT * FROM mytable LIMIT 100; >From the above page: -------------- The LIMIT clause places an upper bound on the number of rows returned in the result. A negative LIMIT indicates no upper bound. The optional OFFSET following LIMIT specifies how many rows to skip at the beginning of the result set. In a compound query, the LIMIT clause may only appear on the final SELECT statement. The limit is applied to the entire query not to the individual SELECT statement to which it is attached. Note that if the OFFSET keyword is used in the LIMIT clause, then the limit is the first number and the offset is the second number. If a comma is used instead of the OFFSET keyword, then the offset is the first number and the limit is the second number. This seeming contradition is intentional - it maximizes compatibility with legacy SQL database systems. -------------- BTW, for transportability, I'm not sure that the SQL specifications allow one to make any assumptions about the ordering of rows when you don't use an ORDER BY clause. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, November 02, 2006 10:10 AM To: sqlite-users@sqlite.org Subject: [sqlite] query limited Hello, somebody know a way for create a query limited, for example, select 100 lines of a table that have 1000000, without to use where clause, like do Ms SQLServer with select top. Thanks. ------------------------------------------------ CiberCorreos® Acercando las Nuevas Tecnologías a la población. http://www.ciudadano.cu/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
