How To Use Pivot In SQL Query.

Anonymous User 1769 29 Oct 2015

Can anyone please help me how to solve this problem.

Ask by Anonymous User

Updated 29 Oct 2015

1 Answers

Anonymous User 29 Oct 2015

lets Step one create order table

create table [Order]
(
 OrderID int primary key identity(1,1),
 Orderdate datetime,
 amount decimal(10,2)
)
now select sample query from order table
 
SELECT year(Orderdate) as [year], left(datename(month,Orderdate),3)as [month], 
amount as Amount FROM [Order] as InvoiceResult

Now write pivot Query .

SELECT *
FROM (
    SELECT
        year(Orderdate) as [year],left(datename(month,Orderdate),3)as [month], 
        amount as Amount 
    FROM [Order]
) as s
PIVOT
(
    SUM(Amount)
    FOR [month] IN (jan, feb, mar, apr,
    may, jun, jul, aug, sep, oct, nov, dec)
)AS Result

Markdown for AI

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

Open .md

forum

How To Use Pivot In SQL Query.

Can you answer this question?

1 Answers