Re: retrieving specified rows - Mailing list pgsql-novice

From A. Kretschmer
Subject Re: retrieving specified rows
Date
Msg-id 20060421082717.GD25454@webserv.wug-glas.de
Whole thread Raw
In response to retrieving specified rows  (kadil <ksadil@bigpond.net.au>)
List pgsql-novice
am  21.04.2006, um 14:59:23 +1000 mailte kadil folgendes:
> Does anyone have an elegant way (sql) to query:
>
> select (various columns) from (several joined tables) where
> (resultset_row_numbers is between specified_first_row and
> specified_last_row)

LIMIT and OFFSET

select foo from bla oder by 1 limit 2 offset 3;


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-novice by date:

Previous
From: kadil
Date:
Subject: retrieving specified rows
Next
From: Andrew Chambers
Date:
Subject: Re: Colors/bold chars in a select?