Chapter 5 Window Functions Flashcards

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