gogo z3r0 | MySQL - uPaste.me!

viewing paste gogo z3r0 | MySQL

Posted on the 29th April, 2012 at 16:10:44

Copied to clipboard

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

Viewed 858 times, submitted by Guest.

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