????6??????????WHERE??HAVING???

??????????????????WHERE????????HAVING???????????????????????

?????? WHERE?????GROUP BY???????SQL?????????????WHERE???

?????? HAVING?????GROUP BY??????SQL?????????????HAVING???

????7????t???????????????

???????????????????????????????????????????????????????????????????顣???????t?????????????????????磬????????????????????????????

SELECT OrderID?? Sum(Cost * Quantity) AS OrderTotal

FROM Orders GROUP BY OrderID

??????????????????????SELECT??GROUP BY?б????????SELECT?????????????????????????????

????8???????????

?????????????????????????????????????????SQL??ROLLUP??????????????????????????????????????????????????t?????????????????е????м??????????????????????????????OrderTotal??

SELECT Customer?? OrderNumber?? Sum(Cost * Quantity)

AS OrderTotal FROM Orders GROUP BY Customer??

OrderNumber WITH ROLLUP

??????????????????20??25 OderTotal?????飬ROLLUP??????OrderTotal?45??ROLLUP????е?????????????????????????з?????????????????????????????

????ROLLUP????????в???? DISTINCT????????GROUP BY ALL???

????9??????????

????CUBE????????ROLLUP???????????????????????????????????????????ROLLUP???????????λ?????????CUBE???????????????????????????????????????????λ?????????

SELECT Customer?? OrderNumber?? Sum(Cost * Quantity)

AS OrderTotal FROM Orders GROUP BY Customer??

OrderNumber WITH CUBE

????CUBE?????????????????????????ROLLUP??????????????????????????У????仰???CUBE?????????????????

????CUBE?????GROUP BY ALL???

????10?????????????

??????CUBE????????????????????????????????????????GROUPING???????????????

SELECT GROUPING(Customer)?? OrderNumber??

Sum(Cost * Quantity) AS OrderTotal FROM Orders GROUP

BY Customer?? OrderNumber WITH CUBE

???????????а???????????????

?????? ?1?????????????????????ROLLUP??CUBE?????????

?????? ?0??????????????????GROUP BY????????????????