Mungkin query ini bisa membantu: Ambil data mangga untuk bulan MAR ======================================= SELECT * FROM (select ITEM,'JAN' AS BULAN ,JAN AS AMOUNT from TABLE_X UNION ALL select ITEM,'FEB' AS BULAN ,FEB AS AMOUNT from TABLE_X UNION ALL select ITEM,'MAR' AS BULAN ,MAR AS AMOUNT from TABLE_X UNION ALL select ITEM,'APR' AS BULAN ,APR AS AMOUNT from TABLE_X UNION ALL select ITEM,'MAY' AS BULAN ,MAY AS AMOUNT from TABLE_X UNION ALL select ITEM,'JUN' AS BULAN ,JUN AS AMOUNT from TABLE_X UNION ALL select ITEM,'JUL' AS BULAN ,JUL AS AMOUNT from TABLE_X UNION ALL select ITEM,'AUG' AS BULAN ,AUG AS AMOUNT from TABLE_X UNION ALL select ITEM,'SEP' AS BULAN ,SEP AS AMOUNT from TABLE_X UNION ALL select ITEM,'OCT' AS BULAN ,OCT AS AMOUNT from TABLE_X UNION ALL select ITEM,'NOV' AS BULAN ,NOV AS AMOUNT from TABLE_X UNION ALL select ITEM,'DES' AS BULAN ,DES AS AMOUNT from TABLE_X
) WHERE ITEM = 'Mangga'and bulan='MAR' / On 9/29/05, Djeni Djelani <[EMAIL PROTECTED]> wrote: > > Halo all > Saya punya table seperti ini > > Item JAN FEB MAR APR MAY JUN JUL AUG > SEP OCT NOV DES > > Mangga 1 4 8 3 2 9 4 8 3 8 1 > 9 > Jeruk 3 7 0 6 2 9 2 7 1 8 4 > 2 > > Jika ingin mengambil Jumlah Item Mangga di bulan SEP syntax nya : > > Select SEP from Table_x where item="Mangga' > > Utk Bulan Jan := Select JAN from Table_x where item='Mangga'; > > Permasalahannya : > Saya Ingin mengambil data Item "Mangga" dengan Kolom bulan sebagai > parameternya, bagaimana caranya ya? > > Ada yang bisa memberi masukan tidak? > > Thx.... > > > > -- > -----------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 > > > > > > > > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------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/
