NTILE « Analytical Functions « Oracle PL / SQL

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