How do I unpivot so that the value column comes at the end?

Question

hello all,&nbsp;&nbsp;I have learning the unpivot function, according to the documentation, the clause before the FOR keyword comes at the end.&nbsp;&nbsp;But when I do it, the column before the FOR keyboard comes before the column after the FOR keyboard.&nbsp;please see this example I did&nbsp;How can I make the value column to be the final column like the documentation?&nbsp;Thanks you.

olafhelper · Answer

By avoiding using the asteriks * in queries, additional you can use subqueries or CTE = common table expression.With subquery it would beSELECT SUB.PersonIdentifier, SUB.col1, SUB.col, SUB.value
FROM
   (SELECT *
    FROM ##temp1
    UNPIVOT (value for col in (col2, col3, col4)) AS up
   ) AS SUB&nbsp;

Forum Discussion

How do I unpivot so that the value column comes at the end?

Share

Resources