CODEWITHSUNDEEP
mysql
Yogasuganya Sukumar
Yogasuganya Sukumar

Reputation: 35

How to get sum of value for specific field

 -------------------------------------------------
SELECT trtm, 
COUNT(CASE WHEN trtm= 'TM' THEN 1 ELSE NULL END) AS Transmission,
COUNT(CASE WHEN trtm= 'TR' THEN 1 ELSE NULL END) AS Transfer,
COUNT(CASE WHEN trtm= 'DL' THEN 1 ELSE NULL END) AS Deletion
(SELECT 
  (SUM( tshares ) AS total WHERE trtm =  'TM'),
  (SUM( tshares ) AS total1 WHERE trtm =  'TR'))
FROM transfer_file
where t_date between '10/1/1992' and '10/2/1992'
 -----------------------------------------------

How to get the sum of values for specific fields,i am getting the count of value but not getting the sum of value,what to do? help me if any body knows

Upvotes: 0

Views: 80

Answers (1)

Giorgos Betsos
Giorgos Betsos

Reputation: 72165

You should use conditional aggregation inside the SUM too:

SELECT trtm, 
COUNT(CASE WHEN trtm= 'TM' THEN 1 ELSE NULL END) AS Transmission,
COUNT(CASE WHEN trtm= 'TR' THEN 1 ELSE NULL END) AS Transfer,
COUNT(CASE WHEN trtm= 'DL' THEN 1 ELSE NULL END) AS Deletion
SUM(CASE WHEN trtm = 'TM' THEN tshares END) AS Total_Transmission,
SUM(CASE WHEN trtm = 'TR' THEN tshares END) AS Total_Transfer
FROM transfer_file
WHERE t_date between '10/1/1992' and '10/2/1992'

Upvotes: 2

Related Questions