By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| lookupID | LookUpValue |
|---|---|
| 1001 | B |
| 1001 | C |
| 1001 | D |
| 1001 | E |
| 1001 | A |
Warning: Null value is eliminated by an aggregate or other SET operation.
| lookupID | LookUpValue |
|---|---|
| 1001 | B |
| 1001 | C |
| 1001 | D |
| 1001 | E |
| 1001 | A |
Warning: Null value is eliminated by an aggregate or other SET operation.