Thanks Donald Griggs and Igor Tandetnik, I have indeed 'taken it to the limit' and it works ok, and I can't believe how quick it works.
Thanks > -----Original Message----- > From: Griggs, Donald [mailto:[EMAIL PROTECTED] > Sent: 16 February 2007 17:49 > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] SQL query - TOP <n> > > > > > Regarding: "It would appear that the "TOP" syntax is not supported by > SQLite (maybe just a Microsoft thing?). However is there an > alternative? " > > Take it to the "LIMIT", Mark. > > > See: > http://sqlite.org/lang_select.html > > > 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. > > [opinions are mine, and not necessarily those of my company] > > -------------------------------------------------------------- > --------------- > To unsubscribe, send email to [EMAIL PROTECTED] > -------------------------------------------------------------- > --------------- > > > DISCLAIMER: This information and any attachments contained in this email message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return email, and delete the original message immediately. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
