Hi Experts,
I have a table like below
Level | Account |
10 | A123 |
11 | A245 |
12 | 123 |
12 | 133 |
12 | 143 |
12 | 153 |
12 | 163 |
12 | 173 |
12 | 183 |
12 | 193 |
11 | A456 |
12 | 456 |
11 | A466 |
12 | 476 |
8 | A567 |
9 | A678 |
10 | A124 |
If I filter the by a where clause A123 it has to check the Level 10 and I need all the numerical values between Level 10 or less than 10 as the result.
123 |
133 |
143 |
153 |
163 |
173 |
183 |
193 |
456 |
466 |
476 |
If I select A245 The result would be