forum

Home / DeveloperSection / Forums / How i can use Pivot Operator?

Ask Question

How i can use Pivot Operator?

Niraj Kumar Mishra 1090 22-Aug-2017
I have a table saller that have following record..

How i can use Pivot Operator?

and i want a query that give  the total ProductSale result  with respect to Name Colmn Like this...
       City                       Rahul               Mohit           Thakur
  Allahabad              300                       200               500
 Jhunsi                       something...
 Phaphamau           something..........

if i use group by keyword then it not give the correct result...please help..





mssql server database 
Updated on 23-Aug-2017
Niraj Kumar Mishra

Niraj Kumar Mishra

Follow

Can you answer this question?

Answer

1 Answers

Samuel Fernandes

Samuel Fernandes

23-Aug-2017
Hi Niraj  you check following query by using Pivot operator it produced same output that you are aspects..

     select *from Saller
     pivot
     (
     sum(ProductSale) for Name in([Rahul],[Mohit],[Thakur])
     )as Pivottable



output is:
answer 524012308050337
best of luck...

Liked By