2008/6/12 Wardiman Sagala <[EMAIL PROTECTED]>: > Teman2 milist, > > Saya mau tanya tentang report matrix. > > query: > > SELECT BT_MCN_NO,BTD_SUPPLY_TEMP SUPPLY_TEMP, BTD_RETURN_TEMP > > RETURN_TEMP, BTD_TIME > > FROM BOILER_TEMP,BOILER_TEMP_DETAIL > > WHERE BT_YEAR=BTD_YEAR > > AND BT_MCN_NO= BTD_MCN_NO > > AND BT_REPORT_NO= BTD_REPORT_NO > > AND BT_DATE=:P_DATE > > yg jadi row: bt_mcn_no > > yg jadi coloumn: btd_time > > yg jadi cell: BTD_SUPPLY_TEMP, BTD_RETURN_TEMP > > data bdt_time: 08, 09, 10, .. 24, 01, 02, 03, 04, 05, 06, 07. > > saat ini report menghasilkan btd_time mulai dari 01 sd 24 (ascending). > > masalahnya gimana supaya tampilan report btd_time (coloumn) dimulai > > dari 08 sd 24, 01,02,03,04,05,06, 07? >
kalau diquerynya ditambahin order by gimana? order by case when btd_time in (01,02,03,04,05,06, 07) then 1 else 2 end desc maaf ya kalau salah. maklum newbie... :)
