Rotating sql table

Posted by Sathish on Stack Overflow See other posts from Stack Overflow or by Sathish
Published on 2010-03-29T11:12:25Z Indexed on 2010/03/29 11:13 UTC
Read the original article Hit count: 395

Filed under:

my sql talble has the following structure

F1      F2     F3     F4     F5 
Group   1      2      3      4  
Design  5      6      7      8 

now i want to read this and return a query result as show below please help

F1      Value 
Group   1    
Group   2    
Group   3    
Group   4 
Design  5       
Design  6   
Design  7   
Design  8   

© Stack Overflow or respective owner

Related posts about sql