how to get sum of same value and different value in same row : **table 1** <br>
invno &emsp;percentage  &emsp; cost <br>
  1       &emsp;&emsp;&emsp;&emsp;18%     &emsp;&emsp;&emsp;18.00  <br>
  1       &emsp;&emsp;&emsp;&emsp;18%     &emsp;&emsp;&emsp;18.00  <br>
  2       &emsp;&emsp;&emsp;&emsp;18%     &emsp;&emsp;&emsp;18.00  <br>
  2       &emsp;&emsp;&emsp;&emsp;28%     &emsp;&emsp;&emsp;28.00  <br>
<br>
**table 2**<br>
 id &emsp;percentage<br>
  1 &emsp;&emsp;&emsp;18%<br>
  2 &emsp;&emsp;&emsp;28%

table 2 percentage is title of output . invno 1 have 2 entry but same percentage sum showing under 18% , but invno 2 have 2 entry different percentage so output sum showing different 
<br>
**output**<br>
invno &emsp;&emsp;percentage 18% &emsp;&emsp;percentage 28% <br>
  1 &emsp;&emsp;&emsp;&emsp;&emsp;&emsp; 36.00  &emsp;&emsp;&emsp;&emsp;&emsp;&emsp;&emsp;0.00<br>
  2  &emsp;&emsp;&emsp;&emsp;&emsp;&emsp;18.00  &emsp;&emsp;&emsp;&emsp;&emsp;&emsp;&emsp;28.00
<br>
please give me mysql query for this output