Received: from mail.utexas.edu (wb3-a.mail.utexas.edu [128.83.126.138]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6B2opa66080 for ; Tue, 10 Jul 2001 22:50:51 -0400 (EDT) (envelope-from webmaster@robbyslaughter.com) Received: (qmail 21626 invoked by uid 0); 11 Jul 2001 02:50:46 -0000 Received: from adsl-208-190-152-103.dsl.austtx.swbell.net (HELO robmanbox) (208.190.152.103) by umbs-smtp-3 with SMTP; 11 Jul 2001 02:50:46 -0000 Reply-To: From: "Robby Slaughter" To: "rajesh" , Subject: RE: "Display of specified number of records." Date: Tue, 10 Jul 2001 21:51:40 -0500 Message-ID: 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 IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: X-Mimeole: Produced By Microsoft MimeOLE V5.50.4133.2400 Importance: Normal X-Archive-Number: 200107/134 X-Sequence-Number: 3926 You want to just display records WHERE the field is BETWEEN 10 and 50? SELECT * FROM test WHERE testID BETWEEN 10 AND 50; If you want them to be ordered by the testID, just include a ORDER BY testID; See, isn't SQL a friendly language? :-) -Robby 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. Rajesh. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster