SELECT ProjectName,T.TowerName ,
CONVERT(NVARCHAR(2),RIGHT('00'+CAST(rank() OVER (ORDER BY T.TowerID) AS VARCHAR(3)),2)) AS TowerID
FROM MasterProperty AS MP
INNER JOIN Tower AS T ON Mp.MasterPropertyID = T.MasterPropertyID
这就是得到的。
这就是我所需要的。
古尔温德·辛格(Gurwinder Singh)
您可以使用row_number窗口功能:
select
t.*,
row_number() over (partition by ProjectName order by TowerId) whatIwant
from your_table t;
我来说两句