SQl Query Group By function

i am trying to find out
customer who has got more clicks and spent amount for yesterday

select c.cust_key, max(c.bllble_clk_cnt) bllble_clk_cnt, max(bllble_clk_rev_amt) bllble_clk_rev_amt

from pfp_acct_dly_fct c where
time_key=TO_NUMBER(TO_CHAR(TRUNC(SYSDATE-1), 'YYYYMMDD'))

group by c.cust_key

But its giving more than one Rec. I need only one.

I appreciate your help.
Thanks Received on Thu Mar 08 2007 - 10:41:43 CST