Re: How to get the first 10 rows of a table

From: Richard W. Zurbuchen <richard.zurbuchen_at_tangensys.com>
Date: Mon, 15 Apr 2002 10:57:36 +0200
Message-ID: <8Cwu8.26267$d45.3921200@monolith.news.easynet.net>

select * from table_name where rownum <= 10

"frank" <frankw_at_qd.lucent.com> schrieb im Newsbeitrag news:a9e2h7$mm4_at_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
>
>
Received on Mon Apr 15 2002 - 03:57:36 CDT

This message: [ Message body ]
Next message: Dominik Zimmerer: "max file size of database"
Previous message: EP: "Re: Why this query is SO slow?"
In reply to: frank: "How to get the first 10 rows of a table"
Next in thread: Ganesh Raja: "Re: How to get the first 10 rows of a table"
Reply: Ganesh Raja: "Re: How to get the first 10 rows of a table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US