我有一个UNPIVOT SELECT语句
SELECT dycd_acnam, dycd_dynam, dycd_value
FROM GCATT.dbo.tblDaycode UNPIVOT (
dycd_value FOR dycd_dynam IN (
Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday)
) AS pvtDaycode
GROUP BY dycd_acnam, dycd_dynam, dycd_value
返回像
这样的值dycd_acnam | dycd_dynam | dycd_value
----------------------------------------
MT | Monday | 1
MT | Tuesday | 1
MT | Wednesday | 0
MT | Thursday | 0
如何在行dycd_acnam
之前添加行号?尝试RANK()
,但它返回错误的值。我想尽量避免使用#Temp表
如果你只想在结果中添加一个递增列,你可以添加
ROW_NUMBER() OVER (ORDER BY (SELECT 0))
到SELECT
列表