CODEWITHSUNDEEP
sql-server
Chanukya
Chanukya

Reputation: 5893

Rotating column values in a table in clockwise direction

I have a table like this 
   c1   c2  c3
    1   2   3
    4   5   6
    7   8   9

I need output like this......       
    c1  c2  c3
    9   1   2
    3   4   5
    6   7   8

I tried but i didn't get any idea if anyone knows the answer please add some explanation for that answer .........

Upvotes: 4

Views: 178

Answers (1)

Abdul Rasheed
Abdul Rasheed

Reputation: 6719

Please try, this may be help you to solve the issue

DECLARE @V_MAX INT 
SELECT  @V_MAX = c3 FROM [tablec]
;WITH CTE_TEST
AS
(   SELECT ROW_NUMBER() OVER(ORDER BY (SELECT 1)) AS ROW_NO,*   FROM [tablec] 
)
SELECT ISNULL(T.c3,@V_MAX) C1,M.c1 C2,M.c2 C3 FROM CTE_TEST M
LEFT OUTER JOIN (SELECT * FROM CTE_TEST T ) T ON T.ROW_NO = M.ROW_NO-1

Upvotes: 3

Related Questions