PHP MYSQL PIVOT TABLE

Langsung saja ada soal seperti ini....ingin buat pivot tablenya agar langsung keluar total

Name      Qty       Value 
Product1 30 1000

Product1 45 2000

Product2 20 1500

Product2 25 3000






Agar tampil seperti ini...

Name      Qty   Value

Product1 75 3000

Product2 45 4500

Total 120 7500

Cuma tinggal buat querynya seperti ini dengan menggunakan aggregate function sum() menggunakan group dengan with rollup:

 

select coalesce(name, `Total`) Name, sum(qty) qty, sum(value) value from ist group by name with rollup

Bagikan

Comments (8)

  • AustOl Cialis Effets Posologie Kamagra Oral Jelly Aus Deutschland Viagra On Sale In Usa <a href=http://sildenaf75mg.com>generic viagra</a> Achat Viagra Ligne France 12 Mei 2019 - 11:15:41 WIB
  • Kelsaulty Kaufen Levitra Baclofene Comment S'En Procurer <a href=http://levipill.com>levitra non prescription</a> Nexium 40 Mg Online Abortion Pill Prices Of Viagra 31 Mei 2019 - 13:34:21 WIB
  • AustOl Cephalexin 500mg Cap Ranbaxy Levitra Where To Buy <a href=http://howtogetvia.com>viagra</a> Cialis At Kmart Pharmacy How To Get A Bottle Of Viagra Isotretinoin secure ordering overseas 06 Juni 2019 - 16:48:17 WIB
  • Kelsaulty Online Viagra Schweiz Acheter Cialis 10mg <a href=http://cdeine.com>viagra</a> Best Price Kamagera No Rx Best Canadian Pharmacy Cialis 10 Juni 2019 - 21:48:57 WIB
  • Kelsaulty Cialis Vendo <a href=http://mdsmeds.com>generic cialis from india</a> Buy 25mg Viagra Online Levitra Free Tadalafil Generic 4 All 04 Juli 2019 - 17:19:03 WIB
  • AustOl Viagra Pills For Sale Uk Does Keflex Make Your Heart Race Prix Cialis Et Levitra <a href=http://buyonlinecial.com>cialis tablets for sale</a> Wholesale Cialis Paid With Paypal Buy Tamoxifen Online Australia Viagra Cialis Levitra Effetti Collaterali 10 Juli 2019 - 18:12:12 WIB
  • Kelsaulty Cialis Lilly Pharma Viagra Joke <a href=http://bmpha.com>equivalent levitra sans ordonnance</a> Global Pharmacy Canada Phone Number Cialis E Hiv Cialis Dopage 17 Juli 2019 - 23:03:51 WIB
  • AustOl Cialis Generic Overnight Shipping <a href=http://viaacost.com>buy viagra</a> Buy Cheap Generic Propecia 28 Juli 2019 - 07:14:50 WIB

Silahkan Tinggalkan Komentar