分页 - 连接查询分页
select top (10) a.id,a.tool_Name,a.tool_Describe from ( select ROW_NUMBER() over(order by u.id) as rownum, t.id,t.tool_Name,t.tool_Describe from Tb_tool as t join Tb_upkeep as u on t.id = u.tool_Id where t.id = 35 ) as a where a.rownum > '0' and a.rownum <= '6'
posted on 2016-01-05 11:52 ultrastrong 阅读(416) 评论(0) 编辑 收藏 举报