I assume Row_Number doesn’t act only on rows of the window frame

Posted by AspOnMyNet on Stack Overflow See other posts from Stack Overflow or by AspOnMyNet
Published on 2010-04-29T20:29:55Z Indexed on 2010/04/30 19:37 UTC
Read the original article Hit count: 637

Filed under:
|
|

a) Quote is taken from http://www.postgresql.org/docs/current/static/tutorial-window.html

for each row, there is a set of rows within its partition called its window frame. Many (but not all) window functions act only on the rows of the window frame, rather than of the whole partition. By default, if ORDER BY is supplied then the frame consists of all rows from the start of the partition up through the current row, plus any following rows that are equal to the current row according to the ORDER BY clause

I assume Row_Number doesn’t act only on rows of the window frame, but instead always act on all rows of a partition?

b)

By default, if ORDER BY is supplied then the frame consists of all rows from the start of the partition up through the current row, plus any following rows that are equal to the current row according to the ORDER BY clause

I assume that is only true for those window functions that act only on rows of the window frame ( thus above quote isn't true for ROW_NUMBER() function )?

c) http://www.postgresql.org/docs/current/static/tutorial-window.html talks about PostgreSQL 8.4’s Windowing functions. Is everything in that article also true for Sql Server 2008’s Windowing functions

thanx

© Stack Overflow or respective owner

Related posts about sql

Related posts about tsql