Pivot table and insert the data into table

Istudent Rana

7y845

This is my situation,

my data in the table is like this

What do i want to achieve is that I want to pivot this data into

and insert the data into new table

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mohsin Arif7y ago
Accepted answer
check this
SELECT
[MailNo], [inboxMessage], [SentMessage]
FROM  ( write here your query) AS SourceTable
PIVOT
(
AVG(mailnumber)
FOR email IN ([MailNo], [inboxMessage], [SentMessage])
) AS PivotTable;
+2
Istudent Rana7y ago
I am not good with Sql. I did not understand pivot funcation at all. I wish if you could show me the query in my above context. I would be grateful to you.
0
Mohsin Arif7y ago
HI
try this link
https://databricks.com/blog/2018/11/01/sql-pivot-converting-rows-to-columns.html

https://www.codeproject.com/Tips/500811/Simple-Way-To-Use-Pivot-In-SQL-Query
0