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