I need to filter commission depend on amount means I give a amount like 300000 and get the commission for those slab where 300000 is match
| SlabStartAmount | SlabEndAmount | CommissionAmount |
|---|---|---|
| 100000 | 200000 | 62.5 |
| 2000001 | 5000000 | 75 |
| 5000001 | 7500000 | 81.25 |
| 7500001 | 10000000 | 87.5 |
| 10000001 | 0 | 100 |
CodePudding user response：
You can use a condition to find out the slab
WHERE @Amount BETWEEN SlabStartAmount AND SlabEndAmount
See this fiddle.