Commitd581348

committed

Adjust documentation wording of window function ORDER BY to not mention

avg() because it was inaccurate.

1 parent8c0f1e2 commitd581348Copy full SHA for d581348

File tree

-4

lines changed

-4

lines changed

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -383,10 +383,10 @@ SELECT depname, empno, salary, avg(salary) OVER (PARTITION BY depname) FROM emps`
`383`	`383`	`</para>`
`384`	`384`
`385`	`385`	`<para>`
`386`		`-Although <function>avg</> will produce thesame result no matter`
`387`		`-what order it processes the partition's rows in, this is not true of all`
`388`		`- windowfunctions. When needed, you can control that order using`
`389`		`-<literal>ORDER BY</> within <literal>OVER</>. Here is an example:`
	`386`	`+You can also control theorder in which rows are processed by`
	`387`	`+window functions using <literal>ORDER BY</> within <literal>OVER</>.`
	`388`	`+(Thewindow<literal>ORDER BY</> does not even have to match the`
	`389`	`+order in which the rows are output.) Here is an example:`
`390`	`390`
`391`	`391`	`<programlisting>`
`392`	`392`	`SELECT depname, empno, salary, rank() OVER (PARTITION BY depname ORDER BY salary DESC) FROM empsalary;`

Comments

(0)