Re: Average - Pg 9.2

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thursday, February 2, 2017, Patrick B <patrickbakerbr@xxxxxxxxx> 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_date,

AVG(id) 

OVER(ORDER BY created_date) AS avr from test

http://sqlfiddle.com/#!15/3289b/1

Maybe...see GROUP BY...

David J.