Can this be done with sql?
От
teknokrat@yahoo.com (teknokrat)
Тема
Can this be done with sql?
Дата
Msg-id
1cbae208.0207031032.7d1be1a2@posting.google.com
Список
Дерево обсуждения
Re: Can this be done with sql? teknokrat@yahoo.com (teknokrat)
Re: Can this be done with sql? "Rajesh Kumar Mallah." <mallah@trade-india.com>
In my database i have values recorded in one minute intervals. I would like a query that can get me results for other time intervals. For example - return maximum value in each 3 minute interval. Any ideas how i can do this with sql? I tried writing a procedure in plsql but i am told it does not support tuples as output. I can get the all the one minute intervals and process them to get me three minute intervals in my application but i would rather not do the expensive call for the one minute intervals in the first place due to the large number of data. any ideas? thanks
В списке pgsql-sql по дате отправления