Re: TOP TEN LISTS? HELP.

Assuming you have an index that would give you the desired order. Example

  table_a field_a char(5) and you want to get top 10 on this field

                            assuming you have an index on this field too.

select rownum, field_a
from table_a
where field_a >= ' ' and -- force use of the index

       rownum <= 10;

--
**************************************************************


*                          Saad Ahmad                        *

*                          McHugh Freeman & Associates, Inc. *

*                          Ph:  (414) 798-8606 Ext. 457      *

*                          Fax: (414) 798-8619               *


*                          E-Mail: sahmad_at_mfa.com            *


**************************************************************