shy421

SELECT CASE WHEN CategoryID='1' THEN Price
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHEN CategoryID='2' THEN Price
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;END
FROM Products
&nbsp;
만약 이렇게 다중 CASE 문을 사용할때 아래 쿼리문을 사용하지 못한다면 어떻게 사용해야할까요?
&nbsp;
SELECT CASE WHEN CategoryID='1' THEN sum(Price)
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHEN CategoryID='2' THEN sum(Price)
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;END
FROM Products