Re: Question about selecting rows - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Question about selecting rows
Date
Msg-id 20060415230352.GA99028@winnie.fuhr.org
Whole thread Raw
In response to Question about selecting rows  ("Hrishikesh Deshmukh" <hdeshmuk@gmail.com>)
List pgsql-general
On Sat, Apr 15, 2006 at 06:44:29PM -0400, Hrishikesh Deshmukh wrote:
> I have a question about selecting rows, my table has 20,000 rows, i want to
> look at rows 5000 to 10,000.

See OFFSET and LIMIT in the SELECT documentation.  Be sure to read
the advice about using ORDER BY.

http://www.postgresql.org/docs/8.1/interactive/sql-select.html#SQL-LIMIT

--
Michael Fuhr

pgsql-general by date:

Previous
From: Douglas McNaught
Date:
Subject: Re: Question about selecting rows
Next
From: Nirmalya Lahiri
Date:
Subject: Re: Update from diferents conditions