Re: Is there anything in oracle similar to top in sql server 2000?

Typically you use rownum. For example,

select * from t1 where rownum < 11;

That's the same as the SQL server top 10.

• Jusung Yang

sohelcsc_at_yahoo.com (Leader) wrote in message news:<b1a93c73.0210230408.ad15189_at_posting.google.com>...
> Hi All,
>
> I have a question? that is in sql server and access we use top to get
> top results from a table.. like
> select top 10 customer from customer_Table.
>
> in oracle what can i use for the above statement???
>
>
> Thanx in Advance
> Hoque
Received on Thu Oct 24 2002 - 19:06:38 CEST