View Single Post

   
  #3 (permalink)  
Old 04-09-2008, 09:19 AM
Michael Fuhr
 
Posts: n/a
Default Re: Question about selecting rows

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/i...html#SQL-LIMIT

--
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Reply With Quote