Bila isi field1 dan field2 itu betul-betul sama, pakai select distinct field1,field2 from...
--- On Fri, 6/3/09, [email protected] <[email protected]> wrote: From: [email protected] <[email protected]> Subject: Re: [indo-oracle] Tanya : Query ??? To: [email protected] Date: Friday, 6 March, 2009, 12:00 PM Alo boss_ayi, Itu field2 cuma tanggal atao ada jamnya juga? Tipedatanya gmn? Untuk tipedata date kan bisa di format seperti ini ('Fielddate','dd/mm/rrrr hh:mi:ss am') Nanti dari situ bisa di order by dgn formatnya. Cmiiw... -----Original Message----- From: "boss_ayi" <[email protected]> Date: Thu, 05 Mar 2009 06:27:35 To: <[email protected]> Subject: [indo-oracle] Tanya : Query ??? salam semuanya,... saya baru gabung nih, dan baru belajar oracle juga. saya punya kasus gini: Field1 Field2 aaa 02-MAR-09 aaa 02-MAR-09 bbb 02-MAR-09 bbb 02-MAR-09 ccc 02-MAR-09 pertanyaannya : gimana caranya nampilin data berdasarkan waktu terakhir (jam terakhir) seperti: Field1 Field2 aaa 02-MAR-09 bbb 02-MAR-09 ccc 02-MAR-09 [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links Get your preferred Email name! Now you can @ymail.com and @rocketmail.com. http://mail.promotions.yahoo.com/newdomains/aa/ [Non-text portions of this message have been removed]
