Re: Question about selecting rows

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Hrishikesh Deshmukh <hdeshmuk(at)gmail(dot)com>
Cc: Postgresql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Question about selecting rows
Date: 2006-04-15 23:03:53
Message-ID: 20060415230352.GA99028@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nirmalya Lahiri 2006-04-16 01:04:59 Re: Update from diferents conditions
Previous Message Douglas McNaught 2006-04-15 22:55:46 Re: Question about selecting rows