I need a special SQL statement...

I am developing an application that interfaces with a rather large oracle database. I have the need to query the top 25 values, and the low 25 values. I know how to sort my data using 'order by', but how do I make it stop querying after the 25 values are recieved?

I know this is a simple question for most of you, thanks in advance for your help!

Michael Natale
Houston, Texas
mdnatale_at_aol.com

   _

   | \
   |   \__________________
   |________\  |___________\       Continental Airlines
                   \ |                            Technology Division
                    \|