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
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