Re: Limiting returned data from SQL Select Satement

Matthew Chappee wrote:

> Is there a way to limit the number of rows returned from an SQL Select
> statement? MS Access supported the following:
>
> Select Top 10 * from table_name
>
> I can't figure out the Oracle equivelant.
>
> Thanks,
>
> Matthew

 Hi,
Use ROWNUM pseudo column to limit the no. of rows returning.

SELECT * FROM TABLE_NAME
WHERE ROWNUM <11;

Hope This Helps

AMARENDRA
Oracle DBA

--
*****************************************************************
AMARENDRA B NETTEM
Oracle Certified DBA (OCP)
Whittman-Hart Inc.,
311 South Wacker Drive, Suite 3500
Chicago, IL 60606.

Residence:
-----------
5039 N E River Road,
Apt. 1A
NORRIDGE, IL 60656


Ph.No. (708) 583 9870 (H)
       (312) 913 6758 (W)

 E-mail:nettama_at_charlie.cns.iit.edu,
        anettem_at_whittman-hart.com

Homepage: http://www.iit.edu/~nettama

****************************************************************
Opinions are mine and do not necessarily reflect those
of Whittman-hart Inc.