在SQL中选择Row As Column [英] Select Row As Column in SQL

问题描述

我需要那个

选择SQL ROW

作为SQL COLUMNS



例子

I Need that
Select SQL ROW
as SQL COLUMNS

Example

Select
      ProductCode,
      CustomerCode,
      Sum(SALEQTY)
      from PRODUCTSALE group by ProductCode,CustomerCode

ProductCode CustomerCode	SALEQTY
M503DA    	00000001	1
M503DA    	00000002	1
M503DF    	00000003	1
M503DF    	00000004	3
M502DA    	00000005	1
M510CF    	00000006	1
M502DA    	00000007	1
M502DF    	00000008	9
M503DA    	00000009	1
M503DF    	00000010	8
M502DA    	00000011	5
M510CF    	00000012	1
M503DA    	00000013	1
M503DF    	00000014	1
M510CA    	00000015	2
M515CF    	00000016	1
M502DF    	00000017	1

i需要产品代码作为列和Valu e SALEQTY

我该怎么办？

i need Product code As Columns and Value SALEQTY
what should i do ??

推荐答案

使用piviot功能。以下是一些参考链接。



http://stackoverflow.com/questions/15931607/convert-rows-to-columns-using-pivot-in-sql-server [ ^ ]

http://stackoverflow.com/questions/ 15931607 / convert-rows-to-columns-using-pivot-in-sql-server [ ^ ]

在SQL查询中使用数据透视的简单方法 [ ^ ]

http://technet.microsoft.com/en-in/library/ms177410(v = sql.105）.aspx [ ^ ]

Use piviot feature. Following are some link for reference.

http://stackoverflow.com/questions/15931607/convert-rows-to-columns-using-pivot-in-sql-server[^]
http://stackoverflow.com/questions/15931607/convert-rows-to-columns-using-pivot-in-sql-server[^]
Simple Way To Use Pivot In SQL Query[^]
http://technet.microsoft.com/en-in/library/ms177410(v=sql.105).aspx[^]

这篇关于在SQL中选择Row As Column的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！