kl sy lihat, ini masalahnya justru di group by nya itu. misalkan gini
select sum(amount), case when a is null then 1 when c is null then 2 dst else .... end from table group by ( nah disini harus nulis lagi di group by nya) case when a is null then 1 when c is null then 2 dst else .... end gak bisa group by "alias" nya saja gitu . tetapi hrs nulis dr mulai 'case' sampe 'end'. maaf gak membantu, soalnya juga gak ngerti solusinya. On Thu, 23 Mar 2006, Syauqi wrote: > Eh, kenapa kok gak GROUP BY no_cust ? > > Sorry klo tambah bingung... > Syauqi > > On 3/23/06, abang sunda <[EMAIL PROTECTED]> wrote: >> dear all, >> mo tanya soal sql plus statement. >> gimana caranya group by memakai column alias ? >> >> mis : select no_cust CUST_, sum(amount) from tableA >> group by CUST_ ? >> >> kok selalu error. >> jadi kurang praktis kalo misalnya memakai >> case >> when ..... >> when ..... >> else >> ... >> end. >> >> kan harus mengulang syntax dr 'case sampai end' >> di group by nya ? >> >> maaf kl membingungkan kata2nya. >> >> oracle 9i -- -----------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/
