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 | 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 ... |
| | tinggal disum differencenya terus group by bukan sih |
| | select nama,count(nama) from table group by nama. |
| | SELECT DATEDIFF(selesai - mulai) FROM table GROUP BY nama |
| | oh count tanggal -.-;a pake yang ^ |
| | menuju TKP.. |
| | hanya mau hasil itu kan? ya gini aja jg bisa:
SELECT `nama`, RIGHT(`selesai`, 1) FROM `tabelnya`
# ga jelas tuh maksud case2 nya apaan.. |
| | selisih hari pake datediff sprri contoh agan Candra Nur Ihsan dah (y) itu | | |
|
Tidak ada komentar:
Posting Komentar