View Single Post
  #2 (permalink)  
Old 09-23-2007, 05:27 PM
shashi jain shashi jain is offline
Junior Member
 
Join Date: Sep 2007
Posts: 3
shashi jain is on a distinguished road
Lightbulb ANY answer. Re: Stuck with a query question

Customers.......TotalSpending
Cust.1............$2300
Cust.2............$1100
etc.................etc...


select customers , TotalSpending
from CustomerValues
where TotalSpending > (select 0.8* sum(TotalSpending)
from customerValues);
Reply With Quote