Sqlsever数据表二维表转为一维表怎么写

怎样把数据库中二维表转换成表格中一维表的形式，如图

SQL Chaoniubi欢 发布于 2023-10-18 10:41 （编辑于 2023-10-18 15:08）

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：0 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共1回答

最佳回答

Z4u3z1Lv6专家互助
发布于2023-10-18 10:42（编辑于 2023-10-18 15:14）

https://www.baidu.com/link?url=sXtn6AygWpiVxMsIt6gpznQ9w8S_LEloGE1MYHsXpUFnlcOan7hCa8Ogstw2XTnfDOE2l71fLhlavHohLIirt7Xp8rt7rO7dElayJNi8XnK&wd=&eqid=b8eaf6a6000c7a5d00000006652f460c 参考列转行

-------

select row_number() over(order by fmonth desc) as fmonth,PRODUCT_NUM,t.area,t.ma from(

select fmonth,PRODUCT_NUM,'0-30天' [area],[0-30_QUANTITY] [ma] from [dbo].[DM_T01_STOCK_TOTAL] union all

select fmonth,PRODUCT_NUM,'31-60天',[30-60_QUANTITY] from [dbo].[DM_T01_STOCK_TOTAL] union all

select fmonth,PRODUCT_NUM,'61-90天',[60-90_QUANTITY] from [dbo].[DM_T01_STOCK_TOTAL] union all

select fmonth,PRODUCT_NUM,'91-120天',[90-120_QUANTITY] from [dbo].[DM_T01_STOCK_TOTAL] union all

select fmonth,PRODUCT_NUM,'121-180天',[120-180_QUANTITY] from [dbo].[DM_T01_STOCK_TOTAL]

) t Where ma is not null order by fmonth asc

举报收起评论(3)

Chaoniubi欢(提问者) select row_number() over(order by fmonth desc) as fmonth,PRODUCT_NUM,t.area,t.ma from( select fmonth,PRODUCT_NUM,area=\'0-30天\',ma=\'0-30_QUANTITY\' from [dbo].[DM_T01_STOCK_TOTAL] union all select fmonth,PRODUCT_NUM,area=\'31-60天\',ma=\'30-60_QUANTITY\' from [dbo].[DM_T01_STOCK_TOTAL] union all select fmonth,PRODUCT_NUM,area=\'61-90天\',ma=\'60-90_QUANTITY\' from [dbo].[DM_T01_STOCK_TOTAL] union all select fmonth,PRODUCT_NUM,area=\'91-120天\',ma=\'90-120_QUANTITY\' from [dbo].[DM_T01_STOCK_TOTAL] union all select fmonth,PRODUCT_NUM,area=\'121-180天\',ma=\'120-180_QUANTITY\' from [dbo].[DM_T01_STOCK_TOTAL] ) t Where ma is not null order by fmonth asc 这个能帮忙看下，哪里错了吗

2023-10-18 15:07