Sqlserver高性能分页 

select   *   from(       
          select   OrderId,   Freight,   ROW_NUMBER()   OVER(order   by   Freight)   as   row   from   Orders       
  )   a       
  where   row   between   20   and   30

 

posted @ 2012-06-02 09:41  苦逼面条  阅读(149)  评论(0)  编辑  收藏  举报