[prev in list] [next in list] [prev in thread] [next in thread] 

List:       solid
Subject:    Re: Limits
From:       Dave Campbell <campbell () geospiza ! com>
Date:       2000-11-02 16:45:04
[Download RAW message or body]

Craig wrote:
> 
> How do you limit the rows returned in a result set in SOLID?

With a 'WHERE' clause! (just kidding).  You can use the 'pseudo column'
ROWNUM like so:

SELECT * FROM my_table
WHERE ROWNUM < 10;

This will return the first 9 rows.

Hope this helps...

Dave Campbell

[prev in list] [next in list] [prev in thread] [next in thread]