help on SQL

From: Kenneth Suralta <ksuralta(at)ntsp(dot)nec(dot)co(dot)jp>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: help on SQL
Date: 2004-04-21 07:07:07
Message-ID: 40861D9B.10403@hq.ntsp.nec.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces


hello everyone,

is it possible to get every other row in the table?
like for example:
data
-----
1
2
3
4
5
6
7

Is it possible to have this result (interval of 3)?

result
------
1
4
7

thanks,
kenneth

--

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Gergely Czuczy 2004-04-21 07:09:26 Re: help on SQL
Previous Message bcsaba 2004-04-21 05:57:04 BLIBPQ.LIB, BLIBPQDLL.LIB or LIBPQ 7.4 problem