Quick Links

"Display of specified number of records."

From:	rajesh(dot)prabhu(at)lycos(dot)com (rajesh)
To:	pgsql-sql(at)postgresql(dot)org
Subject:	"Display of specified number of records."
Date:	2001-07-06 10:47:12
Message-ID:	f3522ac.0107060247.cad5295@posting.google.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

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.

Responses

Re: "Display of specified number of records." at 2001-07-10 17:13:22 from Gene the Dancing Machine
RE: "Display of specified number of records." at 2001-07-11 02:51:40 from Robby Slaughter
Re: "Display of specified number of records." at 2001-07-11 09:10:51 from Richard Huxton

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Daniel Åkerud	2001-07-06 12:40:08	Transactions within a function
Previous Message	Richard Huxton	2001-07-06 10:10:34	Re: ConnecDB() -- couldn't send SSL negotiation packet: