Skip site navigation (1) Skip section navigation (2)

Re: selection limit

From: "Muhyiddin A(dot)M Hayat" <middink(at)indo(dot)net(dot)id>
To: "cristi" <cristi(at)dmhi(dot)ct(dot)ro>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: selection limit
Date: 2003-10-25 09:15:29
Message-ID: 001701c39ad8$893dd490$1f00a8c0@middinkcomp (view raw or flat)
Thread:
Lists: pgsql-novice
----- Original Message ----- 
From: "cristi" <cristi(at)dmhi(dot)ct(dot)ro>
To: <pgsql-novice(at)postgresql(dot)org>
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
from
> 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
50
> 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 GanainmDate: 2003-10-25 20:31:52
Subject: Re: advice
Previous:From: cristiDate: 2003-10-25 05:29:23
Subject: selection limit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group