SQL Help

From: Naren <narendra_gurujuNOnaSPAM_at_spincircuit.com.invalid>
Date: 2000/06/21
Message-ID: <125e88a0.375d44dd@usw-ex0102-084.remarq.com>#1/1

Hello,

Can any one help me come up with an sql query to return first 10 rows and the allow a (web) user to get next 10 rows from a table and so on. These rows should be order by date, title,name. What is a good way of doing it with out a huge performance hit. Can I use rownum or rank functions?

The oracle version is 8i and front end is java.

Thanks,

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Wed Jun 21 2000 - 00:00:00 CDT