pankaj semwal wrote:
In MySQL we use limit query
Like select * from mytable limit 1 3.
But in oracle how we can perform this type of query for pagination.
I googled and find the below query
select * from (select a.*, rownum my_limiter from emp2 a ) where my_limiter between 1 and 3
Is this good way to use this query for pagination.
Please help me.