Oracle PL/SQL: NTILE - Divides an ordered data set into a number of buckets indicated by expr and assigns the appropriate b

Quick Search:

Oracle PL/SQL: NTILE

Jump to:

Category: >> Oracle PL/SQL >> NTILE

<< last

next >>

Snippet Name: NTILE

Description: Divides an ordered data set into a number of buckets indicated by expr and assigns the appropriate bucket number to each row. The buckets are numbered 1 through expr. The expr value must resolve to a positive constant for each partition.

Also see:
» RANK
» REGR_SLOPE
» VARIANCE
» VAR_SAMP
» VAR_POP
» SUM
» STDDEV_SAMP
» STDDEV_POP
» STDDEV
» ROW_NUMBER
» REGR_SYY
» REGR_SXY
» REGR_SXX
» REGR_R2
» REGR_INTERCEPT
» REGR_COUNT
» REGR_AVGY
» REGR_AVGX
» Number Functions: RATIO_TO_REPORT
» Number Functions: RANK
» PERCENTILE_DISC
» PERCENTILE_CONT
» PERCENT_RANK
» OVER PARTITION BY
» MIN
» MAX
» LEAD
» LAST_VALUE
» LAST
» LAG

Comment: See the REGR_AVGX Demo

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 02nd, 2009

NTILE (<expression>) OVER ([query_partition_clause] <order BY clause>)
 
conn oe/oe
 
SELECT last_name, salary,
NTILE(4) OVER (ORDER BY salary DESC) AS quartile
FROM employees
WHERE department_id = 100;