select * from baju order by substr(kode_baju,1,1), substr(kode_baju,3,4) mungkin itu yg dimaksud
________________________________ From: Mx7 <[email protected]> To: [email protected] Sent: Tue, December 1, 2009 9:26:29 PM 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 <ak.rpl2...@gmail. com> To: indo-oracle@ yahoogroups. com 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] [Non-text portions of this message have been removed]
