Chapter 5 Window Functions Flashcards

(2 cards)

1
Q

Window functions

A

Can take multiple rows of data and process them, but still retain all the information in the rows (ranking)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

OVER, PARTITION BY, ORDER BY

A

Create the foundation to unlock the power of WINDOW functions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly