GOT IT!

Create a test table.. Here's the code

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);
[download]

We want to see record 5 to 7..

For mySQL

SELECT string, num
FROM test_table limit 4,3
[download]

For Oracle

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