Walah permintaannya koq aneh2 ya. beginikah maksud anda? SELECT kode_baju FROM BAJU ORDER BY substr(KODE_BAJU,1,1)desc, substr(KODE_BAJU,2)asc ;
Select substr(kode_baju,1,1) Awal ----- Original Message ----- From: Mx7 To: [email protected] Sent: Tuesday, December 01, 2009 9:26 AM Subject: Re: [indo-oracle] Mx7 - Urutan Bukan itu maksudnya mas ... kalo pake desc hasilnya jadi : J-0002 J-0001 B-0004 B-0003 B-0002 B-0001 sedangkan saya pengennya jadi : J-0001 J-0002 B-0001 B-0002 B-0003 B-0004 apakah bisa ? atau memang ngga bisa? mohon bimbingannya terima kasih .. ________________________________ From: Andi Kurniawan <[email protected]> To: [email protected] Sent: Tue, December 1, 2009 3:19:49 PM Subject: RE: [indo-oracle] Mx7 - Urutan Maksudnya pake descending sort ya Mas? select * from baju order by (kode_baju)desc; From: indo-oracle@ yahoogroups. com [mailto:indo-oracle@ yahoogroups. com] On Behalf Of Mx7 Sent: Tuesday, December 01, 2009 2:20 PM To: indo-oracle@ yahoogroups. com Subject: [indo-oracle] Mx7 - Urutan @all iya thx semuanya .. dah saya coba pake commit agar data2 yang telah di update, delete, dsb ngga ilang lagi .. ada pertanyaan lain soal urutan yang ditampilkan .... saya coba ketik : select * from baju order by kode_baju; KODE_BAJU ------------ - B-0001 B-0002 B-0003 B-0004 J-0001 J-0002 pertanyaannya : 1. Gimana caranya agar hasilnya urutan yang J dulu, baru yang B... maksudnya seperti ini : KODE_BAJU ------------ - J-0001 J-0002 B-0001 B-0002 B-0003 B-0004 mohon bimbingannya ... terima kasih banyak ... [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.709 / Virus Database: 270.14.88/2538 - Release Date: 12/01/09 02:59:00 [Non-text portions of this message have been removed]
