PUBLIC:Re: Top 10

rsenn wrote:
>
> While browsing through some Microsoft stuff the other day I ran across a
> SQL line that suggested one can SELECT TOP 10 or SELECT TOP 10% (or
> other number). I'm not aware of equivalent features for use in
> Oracle. Are there?

Try:

Select *
from xyz
where rownum <= 10

and you get the first 10 rows of the select result

rgds
eugen Received on Mon Dec 29 1997 - 00:00:00 CST