On Thursday, February 2, 2017, Patrick B <patrickbake...@gmail.com> 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.
