December, 2014

sql-aggregate functions

December 21, 2014 admin SQL, 0

Using  Rollup, Cube, Grouping and Grouping Sets. Rollup – operation: It is a sub-class of group by-clause, aggregating the select statement’s output. For our test, the promotions – table in sh schema is used,    SELECT P.PROMO_CATEGORY,          P.PROMO_END_DATE,          P.PROMO_COST     FROM PROMOTIONS P ORDER BY P.PROMO_CATEGORY; PROMO_CATEGORY   […]