5
Reply

SQL Query to convert column to row

Amitesh Verma

Amitesh Verma

Sep 23 2015 6:00 AM
530
i want to convert the data from column to row
 
 
my data is 
week  percentachieve
Week1     0.002
Week2     0.004
Week3     0.003
Week4     0.003
Week5     0.002
Week6     0.014 
 
 
new data would be like 
 
week1  week2 week3 week4 week5 week6
0.002    0.004   0.003   0.003   0.002   0.014
 
 
 
 
 
help needed
 

Answers (5)