On Thursday, February 2, 2017, Patrick B wrote:
> Hi guys,
>
> I've got a table which has id and created date columns.
>
> I want to get the average of inserted rows monthly.
> How can I get this data?
>
> This query is not working as it is showing me same data in both columns.
>
> select created
Hi guys,
I've got a table which has id and created date columns.
I want to get the average of inserted rows monthly.
How can I get this data?
This query is not working as it is showing me same data in both columns.
select created_date,
AVG(id)
OVER(ORDER BY created_date) AS avr from test
http:
