CODEWITHSUNDEEP
sql-server
Rishav Dry
Rishav Dry

Reputation: 11

SQL- Pivot and aggregation

Hi I am trying to pivot a table that looks like this:

enter image description here

However I keep getting invalid column name error for placement_name. This is for SQL Server 

Select PLACEMENT_NAME, 'MALE 18-20','MALE 13-17'
      FROM
      (SELECT PLACEMENT_NAME, DEMO_NAME
       FROM myTable) up
      pivot
      (max(placement_name) for DEMO_NAME in (['MALE 18-20'], ['MALE 13-17'])
      )AS pvt;

Upvotes: 0

Views: 34

Answers (2)

Juan Carlos Oropeza
Juan Carlos Oropeza

Reputation: 48197

Single Quotes 'male'are for strings, you need [] to indicate fieldName

Select PLACEMENT_NAME, [MALE 18-20], [MALE 13-17]
....
.... for DEMO_NAME in ([MALE 18-20], [MALE 13-17])

Upvotes: 2

user7715598
user7715598

Reputation:

Try like this

Select PLACEMENT_NAME, [MALE 18-20],[MALE 13-17]
      FROM
      (SELECT PLACEMENT_NAME, DEMO_NAME
       FROM myTable) up
      pivot
      (max(placement_name) for DEMO_NAME in ([MALE 18-20], [MALE 13-17])
      )AS pvt;

Upvotes: 0

Related Questions