[T-SQL] select 資料時，依結果自動產生流水號

自動產生流水號
select ROW_NUMBER() OVER(ORDER BY [recordName]) AS RNO from [tableName]