Jump to content

Edit History

abdullacm

abdullacm


added sum of value column 

SELECT name, COUNT(*) AS total_used, SUM(value) AS total_value
FROM ps_order_cart_rule
GROUP BY name

try this sql :)

abdullacm

abdullacm 

SELECT name, COUNT(*) AS total_used
FROM ps_order_cart_rule
GROUP BY name

try this sql :)

×
×
  • Create New...