Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to get the first 10 rows of a table
Richard W. Zurbuchen wrote:
What is your meaning of the first ten rows. Oracle does not store the Rows in any order and does not fetch rows in any order ... the Above query will just get u the first 10 Rows that oracle has fetched.select * from table_name where rownum <= 10
"frank" <frankw@qd.lucent.com> schrieb im Newsbeitrag
news:a9e2h7$mm4@nntpa.cb.lucent.com...Hi,
I want to know how can I get the first 10 rows of a table's data.
(Oracle 8.1.6)
Thanks in advance
Frank
-- =================================== [Additions and Corrections Welcome] Regards, Ganesh R ===================================