NTILE « Analytical Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Analytical Functions
  3. NTILE
1.NTILE(buckets) to calculate n-tiles: tertiles, quartiles, and so on
2.NTILE(2) OVER (ORDER BY SUM(amount) DESC) AS ntile
3.NTILE(4) function is used for that ordering
4.NTILE(4) in reverse order
5.To get a clearer picture of the NTILE function
6.NTile with NULLS LAST
7.ntile and row_number
8.ntile as quartile