December 2002
Intermediate to advanced
928 pages
85h 29m
English
NTILE (ntile_expr) OVER (analytic_clause)
Divides an ordered data set into a number of buckets and assigns the appropriate bucket number to each row. Analytic function only.
Resolves to a number that specifies the number of buckets to be assigned to rows.