摘要: select * from ( select top 10 * from News where NewsId not in(select top 30 NewsId from News ) )eselect * from (select *,row_number() over(order by badge) rn from 表) awhere rn between @pagesize*(@pageNum-1) and @pagesize*(@pageNum)-1publicDataSetGetList(intPageSize,intPageIndex,stringstrWhere){//sel 阅读全文
posted @ 2011-06-20 12:17 刘佳忻 阅读(167) 评论(0) 推荐(0) 编辑