Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Help with SQL statement, please!
Hello,
I want to select rows from a table where only one field is unique...ie:A customer may have several purchases, but I want to return only the biggest purchases per customer.
I currently have it returning all purchases for every customer, but would like to see only the max value per customer. Here's what I have:
--Received on Fri Jun 30 2000 - 00:00:00 CDT