Re: "select" simple question?

Hi Nikita,

If you want only the first 10 rows in a querie, simply made that querie in the order you desire to be the result, after than, restrict the result with pseudo-column ROWNUM.

Like this:

select * from TAB
  where rownum < 11

I hope this help you.

Bye. Received on Wed Apr 07 1999 - 18:11:15 CDT