drop table test_table;
create table test_table (string varchar(10), num integer);
insert into test_table(string,num) values('a',1);
insert into test_table(string,num) values('b',2);
insert into test_table(string,num) values('c',3);
insert into test_table(string,num) values('d',4);
insert into test_table(string,num) values('e',5);
insert into test_table(string,num) values('f',6);
insert into test_table(string,num) values('g',7);
insert into test_table(string,num) values('h',8);
insert into test_table(string,num) values('i',9);
insert into test_table(string,num) values('j',10);

##</code><code>##

SELECT string, num
FROM test_table limit 4,3

##</code><code>##

select t1.string, t1.num from
(select string, num, rownum rn from test_table) t1 
where t1.rn between 5 and 7;