Re: Newbie-Limiting rows returned in query

Yes , try use rownum keyword.

select * from table where rownum < 10;

John Shaft wrote in message ...
>Does Oracke offer some way to liit the rows returned in a query? For
>instance say I want so select all the rows in a table sorted by name, but
>I only want the first ten names. Can I limit to rows 1-10?
>
>Thanks!
>
>shaft_at_meanmutha.com
>http://www.meanmutha.com
>
Received on Fri Dec 17 1999 - 22:13:51 CST