<p>In Oracle, the number of rows returned in an arbitrary query can be limited by filtering on the "virtual" <code>rownum</code> column. Consider the following example, which will return, at most, 10 rows.</p>

<pre>SELECT * FROM all_tables WHERE rownum &lt;= 10</pre>

<p>Is there a simple, generic way to do something similar in Ingres?</p>

Blatantly changing my answer. "Limit 10" works for MySql and others, Ingres uses
```
```
Select First 10 * from myTable
```
```
Ref