Re: select subset???

In our last gripping episode lfto_at_my-deja.com wrote:
> if i have 100 userids in the database....i don't have any idea what
> they're values are.....could be 1-100 or 100,984,1001,etc...
>
> how can i select the first 10 userids????
>
> thanks
> mike
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

select user_id
from dba_users
where rownum < 11;

This will return the first 10 rows retrieved from the table.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.