select * from (select ROW_NUMBER() over(order by id) rows, * from tb_name) as ty_page where ty_page.rows between 1 and 10