Help with SQL statement, please!

From: Newbie \(Joe \) <"Newbie>
Date: 2000/06/30
Message-ID: <jg275.334$Hs3.7458_at_news1.mts.net>#1/1


Hello,

[Quoted] [Quoted]     I want to select rows from a table where only one field is unique...ie:A [Quoted] [Quoted] customer may have several purchases, but I want to return only the biggest [Quoted] purchases per customer.

[Quoted] [Quoted]     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 CEST

Original text of this message