Return first_name, salary and pct_rank = PERCENT_RANK by salary ascending, rounded to 2 decimals.
20 rows with columns first_name, salary, pct_rank — first 3 shown:
| # | |||
|---|---|---|---|
| 1 | Manoj | 25000 | 0 |
| 2 | Imran | 48000 | 0.05 |
| 3 | Pooja | 50000 | 0.11 |
Run your code to see the output here.