selection limit

From: "cristi" <cristi(at)dmhi(dot)ct(dot)ro>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: selection limit
Date: 2003-10-25 05:29:23
Message-ID: 006c01c39ab8$f453d2e0$7201a8c0@dmhi.ct.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Muhyiddin A.M Hayat 2003-10-25 09:15:29 Re: selection limit
Previous Message Jordan S. Jones 2003-10-25 00:33:33 Re: how to create a multi columns return function ?