By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE T(
MATERIAL_NUMBER VARCHAR(50),
PRICE_TYPE VARCHAR(50),
AMOUNT FLOAT
);
INSERT INTO T VALUES ('25IBTTESTSIZEPRE2','MSRP',50);
INSERT INTO T VALUES ('25IBTTESTSIZEPRE2','SELP',250);
SELECT MATERIAL_NUMBER,
SUM(CASE WHEN PRICE_TYPE = 'MSRP' THEN AMOUNT END ) MSRP,
SUM(CASE WHEN PRICE_TYPE = 'SELP' THEN AMOUNT END ) SELP
FROM T
GROUP BY
MATERIAL_NUMBER
| MATERIAL_NUMBER | MSRP | SELP |
|---|---|---|
| 25IBTTESTSIZEPRE2 | 50 | 250 |
Warning: Null value is eliminated by an aggregate or other SET operation.