Window function implementation as a SQL query

Question

How can I implement :

AVG(X) OVER(PARTITION BY SegmentId) AS AvgX

In a SQL query without using AVG(X)?

I can only support sum, count, min, max, but not AVG.

Thanks,

Or.

I removed the extraneous database tags. Feel free to add the one for the database you are really using. AVG() is supported as a window function by all databases (that I know of) that support window functions. — Gordon Linoff
– Gordon Linoff, Commented Nov 19, 2015 at 13:09
is this homework or do you have problems with some entity framework? — ibre5041
– ibre5041, Commented Nov 19, 2015 at 13:12

LDMJoe · Accepted Answer · 2015-11-19 13:27:35Z

1

Conceptually, AVG(X) can be replaced by SUM(X) / COUNT(X)

Is this answer an oversimplification of the problem at hand?

answered Nov 19, 2015 at 13:27

LDMJoe

1,58913 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Fletch · Accepted Answer · 2015-11-19 13:28:31Z

1

This returns the same results, although the context is unclear..

SUM(X) OVER(PARTITION BY SegmentId) / COUNT(X) OVER(PARTITION BY SegmentId)  AS AvgX

answered Nov 19, 2015 at 13:28

Fletch

3771 gold badge7 silver badges23 bronze badges