[研究]T-SQL，替每一筆前面加上流水編號欄位

[研究]T-SQL，替每一筆前面加上流水編號欄位

2025-05-02

環境：Visual Studio 2022 + ASP.NET + WebForm + Web Application + C# + SQL Server 2019 + SQL Server Management Studio (SSMS) 19

********************************************************************************

T-SQL

SELECT Row_number() OVER (ORDER BY SN) AS row_num, [SN], [Field1], [Field2] FROM [MyDB].[dbo].[mytable];

如果 SELECT 較複雜，可用 WITH、、、AS 

WITH myselectresult AS (SELECT [SN], [Field1], [Field2] FROM [MyDB].[dbo].[mytable]) SELECT Row_number() OVER (ORDER BY SN) AS row_num, [SN], [Field1], [Field2] FROM myselectresult;

(完)

相關