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

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 (view raw or flat)
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

pgsql-interfaces by date

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

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