Sorry ... :) Kelupaan ... select cust_, sum(amount) from (select no_cust CUST_, amount from tableA) group by CUST_;
Thanks, Andri l. Vicko > pak vicko, kok di sy keluar error ya: > > ORA-00937: not a single-group group function ? > > On Fri, 24 Mar 2006, andri_l_vicko wrote: > > > Caranya mudah : > > > > select * from > > (select no_cust CUST_, amount from tableA) > > group by CUST_; > > > > Pasti jalan. > > Mudah bukan. > > > -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
