Scribd
Upload
12 views

Windows Function

Window functions allow calculations across related table rows without grouping, retaining each row's identity; they can access more rows than just the current row like aggregates normally would, performing calculations across the rows in a 'window'.

Uploaded by

diwa karn
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
12 views

Windows Function

Window functions allow calculations across related table rows without grouping, retaining each row's identity; they can access more rows than just the current row like aggregates normally would, performing calculations across the rows in a 'window'.

Uploaded by

diwa karn
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

window function

A window function performs a calculation across a set of table rows that are
somehow related to the
current row. This is comparable to the type of calculation that can be done with an
aggregate function.
However, window functions do not cause rows to become grouped into a single output
row like non-
window aggregate calls would. Instead, the rows retain their separate identities.
Behind the scenes,
the window function is able to access more than just the current row of the query
result.

You might also like