dead_lee · 2007-09-07 05:55:04 · 阅读: 319 應該可以用一些OLAP 的函數來生成行序號偽列吧 MS SQL 2005有行號了吧? Oracle用OLAP的話: select row_number() over(ORDER BY fieldName) seq from table order by seq.