# 第十二章 报表和数据仓库运算

- [12.1 将结果集转置为一行](/sql/di-shi-er-zhang-bao-biao-he-shu-ju-cang-ku-yun-suan/12.1-jiang-jie-guo-ji-zhuan-zhi-wei-yi-hang.md)
- [12.2 把结果集转置为多行](/sql/di-shi-er-zhang-bao-biao-he-shu-ju-cang-ku-yun-suan/12.2-ba-jie-guo-ji-zhuan-zhi-wei-duo-hang.md)
- [12.3 反向转置结果集](/sql/di-shi-er-zhang-bao-biao-he-shu-ju-cang-ku-yun-suan/12.3-fan-xiang-zhuan-zhi-jie-guo-ji.md)
- [12.4 将结果集反向转置为一列](/sql/di-shi-er-zhang-bao-biao-he-shu-ju-cang-ku-yun-suan/12.4-jiang-jie-guo-ji-fan-xiang-zhuan-zhi-wei-yi-lie.md)
- [12.5 抑制结果集中的重复值](/sql/di-shi-er-zhang-bao-biao-he-shu-ju-cang-ku-yun-suan/12.5-yi-zhi-jie-guo-ji-zhong-de-zhong-fu-zhi.md)
- [12.6 转置结果集以利于跨行计算](/sql/di-shi-er-zhang-bao-biao-he-shu-ju-cang-ku-yun-suan/12.6-zhuan-zhi-jie-guo-ji-yi-li-yu-kua-hang-ji-suan.md)
- [12.7 创建固定大小的数据桶](/sql/di-shi-er-zhang-bao-biao-he-shu-ju-cang-ku-yun-suan/12.7-chuang-jian-gu-ding-da-xiao-de-shu-ju-tong.md)
- [12.8 创建预定数目的桶](/sql/di-shi-er-zhang-bao-biao-he-shu-ju-cang-ku-yun-suan/12.8-chuang-jian-yu-ding-shu-mu-de-tong.md)
- [12.9 创建横向直方图](/sql/di-shi-er-zhang-bao-biao-he-shu-ju-cang-ku-yun-suan/12.9-chuang-jian-heng-xiang-zhi-fang-tu.md)
- [12.10 创建纵向直方图](/sql/di-shi-er-zhang-bao-biao-he-shu-ju-cang-ku-yun-suan/12.10-chuang-jian-zong-xiang-zhi-fang-tu.md)
- [12.11 返回未包含在GROUP BY中的列](/sql/di-shi-er-zhang-bao-biao-he-shu-ju-cang-ku-yun-suan/12.11-fan-hui-wei-bao-han-zai-group-by-zhong-de-lie.md)
- [12.12 计算简单的小计](/sql/di-shi-er-zhang-bao-biao-he-shu-ju-cang-ku-yun-suan/12.12-ji-suan-jian-dan-de-xiao-ji.md)
- [12.13 计算所有表达式组合的小计](/sql/di-shi-er-zhang-bao-biao-he-shu-ju-cang-ku-yun-suan/12.13-ji-suan-suo-you-biao-da-shi-zu-he-de-xiao-ji.md)
- [12.14 判别非小计的行](/sql/di-shi-er-zhang-bao-biao-he-shu-ju-cang-ku-yun-suan/12.14-pan-bie-fei-xiao-ji-de-hang.md)
- [12.15 使用Case表达式给行做标记](/sql/di-shi-er-zhang-bao-biao-he-shu-ju-cang-ku-yun-suan/12.15-shi-yong-case-biao-da-shi-gei-hang-zuo-biao-ji.md)
- [12.16 创建稀疏矩阵](/sql/di-shi-er-zhang-bao-biao-he-shu-ju-cang-ku-yun-suan/12.16-chuang-jian-xi-shu-ju-zhen.md)
- [12.17 按时间单位给行分组](/sql/di-shi-er-zhang-bao-biao-he-shu-ju-cang-ku-yun-suan/12.17-an-shi-jian-dan-wei-gei-hang-fen-zu.md)
- [12.18 对不同组/分区同时实现聚集](/sql/di-shi-er-zhang-bao-biao-he-shu-ju-cang-ku-yun-suan/12.18-dui-bu-tong-zu-fen-qu-tong-shi-shi-xian-ju-ji.md)
- [12.19 对移动范围的值进行聚集](/sql/di-shi-er-zhang-bao-biao-he-shu-ju-cang-ku-yun-suan/12.19-dui-yi-dong-fan-wei-de-zhi-jin-hang-ju-ji.md)
- [12.20 转置带小计的结果集](/sql/di-shi-er-zhang-bao-biao-he-shu-ju-cang-ku-yun-suan/12.20-zhuan-zhi-dai-xiao-ji-de-jie-guo-ji.md)