From: | "Vincent Ladlad" <vincentl(at)ntsp(dot)nec(dot)co(dot)jp> |
---|---|
To: | <vincentl(at)ntsp(dot)nec(dot)co(dot)jp> |
Subject: | staggered query? |
Date: | 2004-04-21 02:53:16 |
Message-ID: | 002901c4274b$cb7ace30$643b1cac@Titanium |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
hi! im new to SQL, and i need to find a solution
to this problem:
i have a table with two columns, the first column
is of type timestamp.
the table contains hundreds of thousands of records.
i need to get all the entries/records at every 10 seconds
interval. example, given a table:
hh/mm/ss | data
---------------
00:00:00 1
00:00:01 2
00:00:02 3
00:00:03 4
00:00:04 5
00:00:05 6
00:00:06 7
00:00:07 8
..
..
my query should return:
00:00:10
00:00:20
00:00:30
(etc)
is this possible? if yes, how do i do it?
thanks!
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.484 / Virus Database: 282 - Release Date: 5/27/2003
From | Date | Subject | |
---|---|---|---|
Next Message | Doug McNaught | 2004-04-21 03:04:38 | Re: Connection reset by peer |
Previous Message | Stephan Szabo | 2004-04-21 02:48:40 | Re: PL/SQL question |
From | Date | Subject | |
---|---|---|---|
Next Message | ow | 2004-04-21 03:45:05 | Re: Follow-up: FK constraint performance |
Previous Message | Bruno Wolff III | 2004-04-21 02:00:10 | Re: transaction |