HI,
select * from emp where rownum<6;
TRY THIS
vinay
>
> ----- Original Message -----
> From: "Giovanni Az�a Garc�a" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, December 17, 1999 9:37 PM
> Subject: OFF TOPIC: SQL
>
> > Hello all,
> >
> > I have worked a lot with SQL but I would like to know
> > how could I limit the number of rows one SELECT returns?
> >
> > For example, if I had a table with Customers having for each
> > how much money they have spent in my company and I wanted to
> > know the 5 customers that have spent the most, *ONLY* five:
> >
> > SELECT *
> > FROM CUSTOMER_TABLE
> > ORDER BY MONEY_SPENT; // This would return all rows ordered
> >
> > How could I limit this using SQL specifying the ammount of rows in
> advance?
> >
> > I mean without having to iterate over all existing records.
> > The only approach I have found is using the HAVING option so I could say
> > HAVING MONEY_SPENT > X but how can I determine a X for that there
> > are only Y records.
> >
> > Thanks in advance,
> > Giovanni
> >
> > PD: Maybe I'm expecting too much from SQL
> >
> > BCs. Giovanni Az�a Garc�a
> > Bachelor in Computer Science
> > Banking and Economic Information Center
> > Central Bank of Cuba
> > ICQ# 20725388
> > e-mail: [EMAIL PROTECTED]
> >
> >
> ___________________________________________________________________________
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > Resources: http://java.sun.com/products/servlet/external-resources.html
> > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> >
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
