Originally posted by Amit Kumar Jha:
Hi All ,
I have tried the same query in oracle but after changing the limit like 21 to 30 .it does not give any output.
Suggest me if anything i have left or need to alter in the query, m using oracle as DB.
Thanks in advance.
select * from
(select rownum as rank,m.* from myTable m )
where rank between lower_limit and upper_limit
I think this query will work for you.