Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. SELECT customer_group,sum(invoice_qty) as total,(sum(invoice_qty)*100/totals.tot) as persen,totals.tot as toti FROM (SELECT sum(invoice_qty) as tot FROM report_dpms WHERE sbu = 'SK Jakarta' ) as totals, `report_dpms` WHERE sbu = 'SK Jakarta' GROUP BY customer_group ORDER by SUM(invoice_qty) DESC LIMIT 5
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement