converting column data into column name

Question

this is my table "sample1"

Title          Frequency   Month1      Month2     Month3  Month 4
tution_fee      monthly     april        may       june    july
net_fee         monthly     april        may       june    july
misc            annually    april        may       june    july

I should get a table like this

tution_fee    net_fee      misc
april        april        april
may          may          may       
june         june         june
july         july         july

"sample1" table increases as i add data to it.

Tag the DBMS (i.e. `MySQL`, `SQL Server`, etc..) that you are using. — Yogesh Sharma, Aug 02 '18 at 10:11
SELECT month1 AS tution_fee, month2 as net_fee, month3 as misc FROM YourTable gives what you want. Are you sure that exactly what you want ? — Coskun Ozogul, Aug 02 '18 at 10:18

score 0 · Answer 1 · answered Aug 02 '18 at 10:19

0

You need to use PIVOT

As you didn't mention you specific DBMS we cannot really give you a proper answer.

But with little research you'll find your needs with PIVOT.

answered Aug 02 '18 at 10:19

Cesar

453
9
21

i failed to get the proper answer – viji Aug 02 '18 at 10:36
Database used is MsSql – viji Aug 07 '18 at 06:30

converting column data into column name

1 Answers1