tweety：
我也不太清楚，只是知道用这个函数可以实现sqlserver里top的功能
[阅读: 436] 2005-04-15 09:52:22
select ID from (Select ID,Row_number() over (order by id Desc) rn from table) where rn<6
相当于sqlserver里的
select top 5 ID from table order by id desc
......... @@@@@ @@@@@.........
........ @ @ @ @.........
....... @@@ @ @ .........
...... @@ @ @ .........
...... @@@@@@@ @@@@@ th .......
.... ----------------------- ......
... C E N T U R Y ....
... ----------------------- ...
.. @@@@@ @@@@@ @ @ @@@@@ ..
== @ @ @ @ @ ==
__||__ @ @@@@ @ @ __||__
| | @ @ @ @ @ | |
_________|______|_____ @ @@@@@ @ @ @ _____|______|____
| -ICP -IDC -ISP |