Re: [SQL] how many times
| От | Campbell, Lance |
|---|---|
| Тема | Re: [SQL] how many times |
| Дата | |
| Msg-id | B75CD08C73BD3543B97E4EF3964B7D7047D3FA88@CITESMBX1.ad.uillinois.edu обсуждение исходный текст |
| Ответ на | Re: [SQL] how many times (Rob Sargent <robjsargent@gmail.com>) |
| Список | pgsql-sql |
I appreciate your response but I don’t see how to apply this to five minute time frames?
Thanks,
Lance
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Rob Sargent
Sent: Wednesday, August 23, 2017 1:16 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] how many times
On 08/23/2017 12:03 PM, Campbell, Lance wrote:
I am not for sure how to do the below. I was hoping someone could share their thoughts.
Assume I have a table called T1. It contains a single filed called “viewed” that is of type timestamp.
Every time someone views a particular web page we insert the current timestamp into T1.
Now I need to ask this business question:
On average in any consecutive five minute time frame how many times is the web page viewed?
Thanks,
Lance
window functions are your friends
https://www.postgresql.org/docs/current/static/functions-window.html
В списке pgsql-sql по дате отправления: