4 ms·
cant u use any function as window function (not only 11 ) ? i do alot stuff like sum(1) over(PARTITION BY index1,index2 ORDER by ...) for creating statistics. I
by midmoon 12y ago
cant u use any function as window function (not only 11 ) ?
i do alot stuff like sum(1) over(PARTITION BY index1,index2 ORDER by ...) for creating statistics.
I wish i had that infos some time before :-)
- JohnBooty 12y agoYes, things like sum() can work on partitions. :) "Window functions" refer to something a little different... specifically to functions like row_number() and rank() that refer to the position/ordering of rows inside a partition.