Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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