[MS SQL , DB2]取得select結果列號 ROW_NUMBER( )

範例：
select ROW_NUMBER() OVER (PARTITION BY field1 ORDER BY field2 ASC) AS rownumber FROM table