Sorry kurang paham... bisa tolong di jabarkan? thx

________________________________
From: "[email protected]" <[email protected]>
To: [email protected]
Sent: Mon, August 16, 2010 1:04:35 PM
Subject: Re: [indo-oracle] Query Per Jam

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]

Kirim email ke