我有一个带有 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
? Tried RANK()
但它返回了错误的值。我想尽可能避免使用#Temp 表。
如果您只想将递增列添加到结果中,您可以添加
ROW_NUMBER() OVER (ORDER BY (SELECT 0))
to the SELECT
list
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)