gosi75
asked on
How to make columns to rows and vice versa in SQL
I'm trying to change the structure in my query so that the columns will results as rows and vice versa. Is this possible in any way?
SELECT column1,column2,column3
FROM Table
WHERE (column2 = 'value')
GROUP BY column1,column2,column3
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Here is the code I want to make a pivot, is it possible to do it with the query?
Open in new window