Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQl Query Group By function
<Rajisistla_at_gmail.com> a écrit dans le message de news: 1173373223.286016.21290_at_s48g2000cws.googlegroups.com...
On Mar 8, 11:53 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> <Rajisis..._at_gmail.com> a écrit dans le message de news: 1173372103.534945.216..._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
>>> I need only one Cust_Key
Which one? Received on Thu Mar 08 2007 - 11:28:05 CST