Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

paging

Status
Not open for further replies.

13579

Technical User
Joined
Apr 8, 2001
Messages
8
Location
LK
I have a Search field . When user enters a
value in the Search field, I want to display the first 10 rows
which match the query, then the next 10..and so on. I will give
How do I go about it?
 
You could have ordering problems so I would Write your query in an inline view and then wrap that in a rownum so that you can get ranges. The query may look a little messy but should execute OK.

for example

select ....
from (select col1, col2, ... rownum row_num
from (select col1, col2...
from tab1, tab2 ...
where tab1.a = tab2.b
and other_conditions_here
order by some_column) ilv
) ilv2
where row_num between x and y

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top