Re: Restricting result set to first 10 of 100 without cursor

On Mon, 1 May 2000 16:56:17 -0500, "Scott Buyer" <scottb_at_verio.net> wrote:

>How would you go about selecting a list of 100 names, sort them, and pull
>back only the first ten?
>I want to do this with using a cursor.
>
>--
>
>
>
>
>
>

Use rownum

select * from customers
where rownum < 101 Received on Tue May 02 2000 - 00:00:00 CDT