Unknown #261 | MySQL - uPaste.me!

viewing paste Unknown #261 | MySQL

Posted on the 29th April, 2012 at 16:05:29

Copied to clipboard

SELECT DISTINCT
  (SELECT `player_name`) as pname,
  (SELECT SUM(amount) FROM `table` WHERE `player_name`=pname && `damage_type`='Heal'),
  (SELECT SUM(amount) FROM `table` WHERE `player_name`=pname && `damage_type`='Damage')
FROM `table`
 

Viewed 998 times, submitted by Guest.

SELECT DISTINCT
  (SELECT `player_name`) as pname,
  (SELECT SUM(amount) FROM `table` WHERE `player_name`=pname && `damage_type`='Heal'),
  (SELECT SUM(amount) FROM `table` WHERE `player_name`=pname && `damage_type`='Damage')
FROM `table`