select * from( select id,name,row_number() over(order by id) as 'row' from student)as temp where row=n