select row_number()over(order by xx)rownumber,users.name, goods.sname, orders.time form users 
left join orders on users.uid=orders.uid 
left join goods on orders.sid=goods.sid 
where rownumber between 开始个数 and 结束个数;