# 第十四章 若干另类目标

- [14.1 使用SQL Server的PIVOT运算符创建交叉表报表](/sql/di-shi-si-zhang-ruo-gan-ling-lei-mu-biao/14.1-shi-yong-sql-server-de-pivot-yun-suan-fu-chuang-jian-jiao-cha-biao-bao-biao.md)
- [14.2 使用SQL Server的UNPIVOT运算符反转置交叉表报表](/sql/di-shi-si-zhang-ruo-gan-ling-lei-mu-biao/14.2-shi-yong-sql-server-de-unpivot-yun-suan-fu-fan-zhuan-zhi-jiao-cha-biao-bao-biao.md)
- [14.3 使用Oracle的MODEL子句转换结果集](/sql/di-shi-si-zhang-ruo-gan-ling-lei-mu-biao/14.3-shi-yong-oracle-de-model-zi-ju-zhuan-huan-jie-guo-ji.md)
- [14.4 从不固定位置提取字符串的元素](/sql/di-shi-si-zhang-ruo-gan-ling-lei-mu-biao/14.4-cong-bu-gu-ding-wei-zhi-ti-qu-zi-fu-chuan-de-yuan-su.md)
- [14.5 求一年包含的天数（Oracle的另一种解决方案）](/sql/di-shi-si-zhang-ruo-gan-ling-lei-mu-biao/14.5-qiu-yi-nian-bao-han-de-tian-shu-oracle-de-ling-yi-zhong-jie-jue-fang-an.md)
- [14.6 搜索字母数字混合的字符串](/sql/di-shi-si-zhang-ruo-gan-ling-lei-mu-biao/14.6-sou-suo-zi-mu-shu-zi-hun-he-de-zi-fu-chuan.md)
- [14.7 使用Oracle把整数转换为二进制数](/sql/di-shi-si-zhang-ruo-gan-ling-lei-mu-biao/14.7-shi-yong-oracle-ba-zheng-shu-zhuan-huan-wei-er-jin-zhi-shu.md)
- [14.8 转置已分等级的结果集](/sql/di-shi-si-zhang-ruo-gan-ling-lei-mu-biao/14.8-zhuan-zhi-yi-fen-deng-ji-de-jie-guo-ji.md)
- [14.9 给两次转置的结果集增加列头](/sql/di-shi-si-zhang-ruo-gan-ling-lei-mu-biao/14.9-gei-liang-ci-zhuan-zhi-de-jie-guo-ji-zeng-jia-lie-tou.md)
- [14.10 在Oracle中把标量子查询转换为复合子查询](/sql/di-shi-si-zhang-ruo-gan-ling-lei-mu-biao/14.10-zai-oracle-zhong-ba-biao-liang-zi-cha-xun-zhuan-huan-wei-fu-he-zi-cha-xun.md)
- [14.11 把连续数据分解为行](/sql/di-shi-si-zhang-ruo-gan-ling-lei-mu-biao/14.11-ba-lian-xu-shu-ju-fen-jie-wei-hang.md)
- [14.12 计算相对于总数的百分数](/sql/di-shi-si-zhang-ruo-gan-ling-lei-mu-biao/14.12-ji-suan-xiang-dui-yu-zong-shu-de-bai-fen-shu.md)
- [14.13 从Oracle创建CSV格式输出](/sql/di-shi-si-zhang-ruo-gan-ling-lei-mu-biao/14.13-cong-oracle-chuang-jian-csv-ge-shi-shu-chu.md)
- [14.14 找到与模式不匹配的文本（Oracle）](/sql/di-shi-si-zhang-ruo-gan-ling-lei-mu-biao/14.14-zhao-dao-yu-mo-shi-bu-pi-pei-de-wen-ben-oracle.md)
- [14.15 用内联视图转换数据](/sql/di-shi-si-zhang-ruo-gan-ling-lei-mu-biao/14.15-yong-nei-lian-shi-tu-zhuan-huan-shu-ju.md)
- [14.16 测试一个组内是否存在某个值](/sql/di-shi-si-zhang-ruo-gan-ling-lei-mu-biao/14.16-ce-shi-yi-ge-zu-nei-shi-fou-cun-zai-mou-ge-zhi.md)