Received: from tele-post-20.mail.demon.net (tele-post-20.mail.demon.net [194.217.242.20]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6B9XIa69334 for ; Wed, 11 Jul 2001 05:33:18 -0400 (EDT) (envelope-from dev@archonet.com) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by tele-post-20.mail.demon.net with esmtp (Exim 2.12 #2) id 15KGMs-000CBF-0K; Wed, 11 Jul 2001 09:33:15 +0000 Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id 4CFC412F8B; Wed, 11 Jul 2001 10:10:55 +0100 (BST) Message-ID: <00e901c109e9$6326c640$1001a8c0@archonet.com> From: "Richard Huxton" To: "rajesh" , References: Subject: Re: "Display of specified number of records." Date: Wed, 11 Jul 2001 10:10:51 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200107/140 X-Sequence-Number: 3932 From: "rajesh" > Hi, > I have got following simple SQL. > Select TestID from test where testname = ' ' order by testdate. > > Suppose for argument sake there are 100 records and testID's are 1 > to 100. > Is it possible to modify this SQL so that it will display records > from 10 to 50 and not any other records. Robby Slaughter has given one solution in another reply. If that's not quite what you're after, and you want the 10th to 50th results from the above query you can do: ... order by testdate limit 40 offset 10; This calculates the results and then throws away the first nine and anything after the 50th. - Richard Huxton