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
