Free Preparation Discussions
MENU
Snowflake DSA-C02 Exam - Topic 3 Question 42 Discussion
Topic #: 3
Which of the Following is not type of Windows function in Snowflake?
Window Functions
A window function operates on a group (''window'') of related rows.
Each time a window function is called, it is passed a row (the current row in the window) and the window of rows that contain the current row. The window function returns one output row for each input row. The output depends on the individual row passed to the function and the values of the other rows in the window passed to the function.
Some window functions are order-sensitive. There are two main types of order-sensitive window functions:
Rank-related functions.
Window frame functions.
Rank-related functions list information based on the ''rank'' of a row. For example, if you rank stores in descending order by profit per year, the store with the most profit will be ranked 1; the second-most profitable store will be ranked 2, etc.
Window frame functions allow you to perform rolling operations, such as calculating a running total or a moving average, on a subset of the rows in the window.
Nickolas
5 months agoKeith
5 months agoGlen
6 months agoCarline
6 months agoStefanie
6 months agoCarman
6 months agoCarma
6 months agoMargo
7 months agoDenny
7 months agoValene
7 months agoTennie
7 months agoOcie
7 months agoLeah
8 months agoVirgina
8 months agoFabiola
12 months agoVallie
12 months agoBelen
11 months agoMayra
11 months agoLeonora
11 months agoCristina
11 months agoLong
11 months agoDominga
11 months agoMyra
12 months agoBarrett
1 year agoNelida
1 year agoMariann
1 year agoLai
12 months agoLigia
1 year agoAlishia
1 year ago