NTILE
NTILE divides an ordered data set into a number of buckets indicated by expression and assigns the appropriate bucket number to each row.
Syntax
NTILE (expression1) OVER ( [ PARTITION BY expression [, ...] ]
ORDER BY expression [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] )
Remarks
• The buckets are numbered 1 through expression1.
• The expression1 value must resolve to a positive constant for each partition.
• PARTITION BY is optional.
• ORDER BY is required.
• The window clause is not allowed.