Senin, 28 Oktober 2013

PHP Indonesia - Facebook: gimana SQL statement yehh... nge-count record kala...

PHP Indonesia - Facebook
PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ 
Book your hotel early for a discount!

You can reap the rewards with great discounts at participating Pullman, M Gallery, Grand Mercure, Novotel, Mercure, ibis and Formule 1 hotels.
From our sponsors
gimana SQL statement yehh... nge-count record kala...
Oct 28th 2013, 07:48, by Peter Jack Kambey

Peter Jack Kambey 7:48am Oct 28
gimana SQL statement yehh... nge-count record kalau ada casenya kayak gini

nama | mulai | selesai
foo | 2013-10-01 | 2013-10-01
bar | 2013-10-01 | 2013-10-02
...
result:
foo | 1
bar | 2
...

Petra Novandi Barus 7:51am Oct 28
tinggal disum differencenya terus group by bukan sih

Candra Nur Ihsan 7:51am Oct 28
select nama,count(nama) from table group by nama.

Petra Novandi Barus 7:51am Oct 28
SELECT DATEDIFF(selesai - mulai) FROM table GROUP BY nama

Candra Nur Ihsan 7:52am Oct 28
oh count tanggal -.-;a pake yang ^

Peter Jack Kambey 7:52am Oct 28
menuju TKP..

Al Ghurahy 7:54am Oct 28
hanya mau hasil itu kan? ya gini aja jg bisa:

SELECT `nama`, RIGHT(`selesai`, 1) FROM `tabelnya`

# ga jelas tuh maksud case2 nya apaan..

Al Ghurahy 7:58am Oct 28
selisih hari pake datediff sprri contoh agan Candra Nur Ihsan dah (y) itu

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions

Tidak ada komentar:

Posting Komentar