sql - query calculation between records

Question

This is a simplified representation :

Suppose I have this query :

SELECT DISTINCT T.Description, T.ParamName, T.SetValue, T.ParamID

which returns this result :

Description	ParamName	SetValue	ParamID
PA	Amount1	6	312
PA	Amount2	6	314
PA	Amount3	160	180
PB	Amount2	6	312
PB	Amount1	12	314
PB	Amount3	245	180

Answer 1

You can do what you want using conditional aggregation:

select pa,
       (max(iif(paramname = 'Amount1', setvalue, 0)) +
        max(iif(paramname = 'Amount2', setvalue, 0))
       ) *
        max(iif(paramname = 'Amount3', setvalue, 0)) 
from t
group by pa;