Re: Query Optimization Help needed

Using something like

select acct_num, count(*) from
(select acct# acct_num, fruit
from table
group by acct#, fruit)
group by acct_num

Patrick Lanphier
Advanced Information Technologies
The Pennsylvania State University

knez wrote: Received on Sun Nov 01 1998 - 13:26:59 CST