Percentile Ranking

Write a SQL query to calculate percentile rank for each employee's salary.

Expected Columns

• name
• salary
• percentile

Example Output

| name | salary | percentile | |------|--------|------------| | Karthik Sundaram | 95000 | 100.0 | | Ananya Singh | 90000 | 92.86 | | ... | ... | ... |