Received: from www.base2inc.com (IDENT:root@www.base2inc.com [204.117.190.140]) by hub.org (8.9.2/8.9.1) with ESMTP id UAA19388 for ; Wed, 10 Feb 1999 20:26:18 -0500 (EST) (envelope-from fmorton@base2inc.com) Received: from tesla (tesla.base2inc.com [206.229.85.131]) by www.base2inc.com (8.8.7/8.8.7) with SMTP id UAA07806 for ; Wed, 10 Feb 1999 20:23:39 -0500 Message-ID: <01ae01be555f$0390d4f0$8355e5ce@base2inc.com> From: "Frank Morton" To: Subject: setting select limit? Date: Wed, 10 Feb 1999 20:36:57 -0500 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.0810.800 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.0810.800 If a select is going to match 1000 records, but I only want to select the first 25, I thought I could: select * from table limit 25; But I guess I can't. How do I limit the query? I've search around with no results. Thanks.