<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Under SQL Server 2000 there is the keyword TOP, that force SQL Server to get only the first X rows (SELECT TOP 10 * FROM MyTable 'retieive only the first 10 rows)... <br />
<br />
Is there an equivalent keyword under Oracle DB.<br />
<br />
Tanks<br />
<br />
David
</div>
</div>


Hi,

Under SQL Server 2000 there is the keyword TOP, that force SQL Server to get only the first X rows (SELECT TOP 10 * FROM MyTable 'retieive only the first 10 rows)... 

Is there an equivalent keyword under Oracle DB.

Tanks

David

How to get only first rows of a recordset using Oracle DB

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.