Window Functions
4 items
Window Functions
Window Functions · Advanced
ROW_NUMBER
Assigns a continuous number to rows after ordering or partitioning.
Window Functions · AdvancedRANK
ranking rows with gaps for ties.
Window Functions · AdvancedDENSE_RANK
ranking rows without gaps after ties.
Window Functions · AdvancedLAG
reading a previous row value.