Received: from post.mail.demon.net (post-11.mail.demon.net [194.217.242.40]) by hub.org (8.8.8/8.7.5) with SMTP id RAA20309 for ; Wed, 15 Jul 1998 17:52:15 -0400 (EDT) Received: from (remo.demon.co.uk) [158.152.14.149] by post.mail.demon.net with smtp (Exim 1.82 #2) id 0ywZTB-00076C-00; Wed, 15 Jul 1998 21:52:14 +0000 Received: from taz (taz.lenzie.net [192.168.1.2]) by remo.demon.co.uk (8.8.5/v3.2) with SMTP id UAA27697 for ; Wed, 15 Jul 1998 20:41:45 +0100 From: "Neil Burrows" To: Subject: Restricting number of entries returned Date: Wed, 15 Jul 1998 20:41:44 +0100 Message-ID: <000101bdb028$9917b4d0$0201a8c0@taz.lenzie.net> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Hi, Is there any way of restricting the number or entries returned in an SQL query? For example, if you wanted to do a select that ordered the results by a certain field, and only wanted the "Top 10" entries, is there any way to specify that you just want the 1st 10 records? Thanks in advance, See ya, Neil Burrows /~\ /~\ /~~~~\ E-Mail - neil@remo.demon.co.uk | \| | | () / - nburrows@cs.strath.ac.uk | |\ | | () \ PGP Key - http://www.remo.demon.co.uk/pgp/ \_/ \_/ \____/ Internet - http://www.remo.demon.co.uk/