--oracle

select * from(

select rownum r,t.* from (select * from testtable)t where rownum<80

)where r>=50;

--sqlserver

select * from (

select ROW_NUMBER() over(order by id) as rownum,*from ATTENCE

)a

where rownum between 50 and 80

--mysql

SELECT * FROM test LIMIT 50,80;