Self Join multiple rows in sql and create new columns

Question

I'm trying to join multiple rows having same column DN value and creating view by showing them in multiple columns.

Table is:

OrderID	DN	Attributecode	Attributevalue	Itemcode
150000565101091	14768703	contractId	100000022	Silver_Bundle
150000565101091	14768703	activationDateInherited	11-JAN-21	Silver_Bundle
150000565101091	14768703	contractExpiryDate	11-APR-21	Silver_Bundle

Answer 1

You can use conditional aggregation as follows:

Select orderid, dn, 
       Max(case when atrributecode = 'contractId' then attributevalue end) as contractId,
      Max(case when atrributecode = 'activationDateInherited' then attributevalue end) as activationDateInherited,
      Max(case when atrributecode = 'contractExpiryDate' then attributevalue end) as contractExpiryDate,
       Itemcode
  From t
Group by orderid, dn, itemcode