SQL Window Functions

Does a window function require the use of Group By?

• Yes
• No
• Depends on the function
• Depends on the number of impacted records

To narrow a window function's application to a subgroup within a data set, use __________.

• OVER
• SUBGROUP
• PARTITION BY
• SECTION

Select the term used to identify all rows after the current row in a partition.

• FINAL ROW
• UNBOUNDED FOLLOWING
• END RANGE
• CONTINUE TO END

Which of the following options is not a window function?

• ROW_NUMBER()
• SUM()
• LEAD()
• RUN_TOTAL()

Which of the following options is not a method for numbering or ranking records?

• NUMBER()
• RANK()
• ROW_NUMBER()
• DENSE_RANK()

If an order clause is included, but a window frame is not, which option will be the default frame?

• There is not one - you must include a window frame
• ROWS BETWEEN CURRENT ROW AND CURRENT ROW
• RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
• ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW

Which of the following options is not true about a WINDOW clause?

• It avoids repetition when creating multiple window functions
• It comes before the ORDER BY clause
• It can create an alias for shared PARTITION BY and ORDER BY clauses
• It comes before the WHERE clause

Fill in the blank:  SELECT SUM(qty) __________(PARTITION BY EmpID) AS EmpQty

• ON
• FOR
• OVER
• WINDOW

Select the term used to identify all rows prior to the current row in a partition.

• UNBOUNDED BEGINNING
• BOUNDED BEGINNING
• UNBOUNDED PRECEDING
• BOUNDED PRECEDING

Which term is used to find the first value in a set of data?

• BEGIN_AMT
• START_VALUE
• START_AMT
• FIRST_VALUE