Postgres Pro
Downloads
Home   >   mailing lists

help on SQL - Mailing list pgsql-interfaces

From Kenneth Suralta
Subject help on SQL
Date
Msg-id 40861D9B.10403@hq.ntsp.nec.co.jp
Whole thread Raw
Responses Re: help on SQL  (Gergely Czuczy <phoemix@harmless.hu>)
List pgsql-interfaces
Tree view 
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

--

pgsql-interfaces by date:

Previous
From: bcsaba@balmazujvaros.hu
Date:
Subject: BLIBPQ.LIB, BLIBPQDLL.LIB or LIBPQ 7.4 problem
Next
From: Gergely Czuczy
Date:
Subject: Re: help on SQL