I've this data in my table
| Col1 | Col2 |
| ------------ | ------------ |
| master-milk | 100 |
| submaster-milk | 200 |
| master-coffee | 10 |
| submaster-coffee | 20 |
And I need to calculate SUM() of my milk and coffee Sum(milk) = 300 and sum(coffee) = 30
Select col1,sum(col1) as total from Table
group by col1
3条答案
按热度按时间vs3odd8k1#
You can use a common table expression (CTE) to first categorize the rows and then perform the SUM operation.
cgvd09ve2#
You can use
SUBSTRING
to extract milk/coffee from the string :pcww981p3#
Another solution :