How to get column values as row
I have table as belowName age d1 d2 d3
xxx 20 5 2 1
xxx 20 3 2 1
xxx 20 5 4 6
I need result as unique d column values as below
xxx 20 5
xxx 20 2
xxx 20 1
xxx 20 3
xxx 20 4
xxx 20 6
You must Sign In to post a response.
Category: SQL Server
Name age d1 d2 d3
xxx 20 5 2 1
xxx 20 3 2 1
xxx 20 5 4 6
I need result as unique d column values as below
xxx 20 5
xxx 20 2
xxx 20 1
xxx 20 3
xxx 20 4
xxx 20 6
#769448
Use SQL pivot to achieve your work
Return to Return to Discussion Forum