摘要： 1、select top 10 * from ( select top (@Page * 10) ROW_NUMBER() OVER (order by id)as RowNum, id, username from Guestwhere username = 'user' ) as Twhere RowNum > ((@Page - 1) * 10)2、select * from( sel... 阅读全文