----- Original Message -----
From: "cristi" <cristi(at)dmhi(dot)ct(dot)ro>
Sent: Saturday, October 25, 2003 1:29 PM
Subject: [NOVICE] selection limit
> In this moment I can make a selection of the first (or last) 10 records
> a table.
> select * from table_name limit 10;
> I want to make a selection of the next 10 records (from 10 to 20 or from
> to 60) from a table.
> How can I do that?
select * from table_name limit 10 OFFSET 10;
select * from table_name limit 10 OFFSET 50;
In response to
pgsql-novice by date
|Next:||From: Paul Ganainm||Date: 2003-10-25 20:31:52|
|Subject: Re: advice|
|Previous:||From: cristi||Date: 2003-10-25 05:29:23|
|Subject: selection limit|