sql 分页检索数据

  select * from ( select row_number() over(order by code) row , * from CSH_GCBH) as a
   where a.row between 101 and 110

posted @ 2012-07-18 15:55  顺手  阅读(125)  评论(0)    收藏  举报