Re: SQl Query Group By function

<Rajisistla_at_gmail.com> a écrit dans le message de news: 1173372103.534945.216040_at_v33g2000cwv.googlegroups.com...
|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
|

It gives you what you ask: 1 row per cust_key. What do you want?

Regards
Michel Cadot Received on Thu Mar 08 2007 - 10:53:36 CST