How i can use Pivot Operator?

Niraj Kumar Mishra 1431 22 Aug 2017

I have a table saller that have following record..

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..

1 Answers

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:

best of luck...

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

How i can use Pivot Operator?

Can you answer this question?

1 Answers