How to add total average column - postgreSQL-CodePudding

Home > Software engineering > How to add total average column - postgreSQL

How to add total average column - postgreSQL

Time：04-12

I have this table and I want to add another column to calculate the average of the seconds column. For example:

my table:

my desired table:

Is there any simple and short way to do it? Im using postgreSQL

Thanks

CodePudding user response：

You can use the AVG() window function:

SELECT
    id, avg,
    AVG(avg) OVER () AS daily_avg
FROM mytable