Dear Bima, Coba dengan query :
select to_char(b,'dd Mon yyyy HH24'),count(1) from tester group by to_char(b,'dd Mon yyyy HH24'); asumsi table tester dengan b (datetime masuk) Semoga bermanfaat Edi Sunardi --- Pada Sen, 16/8/10, [email protected] <[email protected]> menulis: Dari: [email protected] <[email protected]> Judul: Re: [indo-oracle] Query Per Jam Kepada: [email protected] Tanggal: Senin, 16 Agustus, 2010, 1:04 PM Di group by aj kk, group bynya ubah pake todate jam aj Sent from my BlackBerry® smartphone from Sinyal Bagus XL, Nyambung Teruuusss...! -----Original Message----- From: bima boediman <[email protected]> Sender: [email protected] Date: Sun, 15 Aug 2010 22:56:43 To: <[email protected]> Reply-To: [email protected] Subject: [indo-oracle] Query Per Jam Met Siang Semua, Saya ada problem neh siapa tau bisa bantu untuk selesaikan : ada 1 table yang isinya : Waktu masuk - Contoh data '21-07-2010 20:34:23' Nah bisa ga bikin laporan berapa orang masuk PER JAM misalnya seperti ini : 21-07-2010 JAM 1 6 Orang - 21-07-2010 JAM 2 10 Orang ---Formatnya sih ga terlalu baku intinya untuk tanggal sekian jam sekian ada sekaian orang masuk. yang penting dalam 1 kalimat select. Capek kan kalau pake 'where waktu masuk between jam sekian and jam sekian' mohon bantuannya para Suhu Oracle.... :D bima Boediman [Non-text portions of this message have been removed] [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 [Non-text portions of this message have been removed]
