By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
| EMPNO | ENAME | SALARY | DIFFERENCE_FROM_AVG | DIFFERENCE_FROM_NEXT | DIFFERENCE_FROM_PREV | DIFFERENCE_FROM_MIN | DIFFERENCE_FROM_MAX |
|---|---|---|---|---|---|---|---|
| 101 | Ashok | 1000 | 1000 | 1000 | 1000 | 0 | 2000 |
| 102 | Kumar | 2000 | 0 | 1000 | 1000 | 1000 | 1000 |
| 103 | Mani | 3000 | 1000 | null | 1000 | 2000 | 0 |