select top 10* from (SELECT row_number() OVER(ORDER BY 关键词)AS RowNumber,* from TmpZTC_standard_promotion_plan_keyword_query) a WHERE RowNumber>(6-1)*10