クリスマス セールの順位と相対的な順位を調べます。
SELECT sales_amt, RANK() OVER (ORDER BY sales_amt), PERCENT_RANK () OVER (ORDER BY sales_amt) FROM xsales;
| sales_amt | Rank | Percent_Rank |
|---|---|---|
| 100.00 | 1 | 0.000000 |
| 120.00 | 2 | 0.125000 |
| 130.00 | 3 | 0.250000 |
| 140.00 | 4 | 0.375000 |
| 143.00 | 5 | 0.500000 |
| 147.00 | 6 | 0.625000 |
| 150.00 | 7 | 0.750000 |
| 155.00 | 8 | 0.875000 |
| 160.00 | 9 | 1.000000 |