| Limit Function [message #374978] |
Tue, 17 July 2001 01:21  |
Ganu
Messages: 2
Registered: July 2001
|
Junior Member |
|
|
HI ,
Is there a Limit function or any equivalent in Oracle. eg
Select * from emp limit 10,20 which returns the data from 10 row to 20 row.
or select * from emp limit 20 which returns first 20 rows(this can be done by rownum)
I require this function to display page wise reports.
Any other solution too is welcome.
Thanks in advance.
|
|
|
|
| Re: Limit Function - URL [message #374979 is a reply to message #374978] |
Tue, 17 July 2001 01:40  |
Ganu
Messages: 2
Registered: July 2001
|
Junior Member |
|
|
Thanks andrew,
for your lightning response.
The below mentioned query helped.
Thnks once again
ganu
select *
from ( select a.*, rownum rnum
from ( YOUR_QUERY_GOES_HERE ) a
where rownum <= MAX_ROWNUMBER )
where rnum >= MIN_ROWNUMBER
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
