PIVOT语句是否有ANSI规范? [英] Is there an ANSI Specification for the PIVOT statement?

问题描述

最近我问了一个问题对于SQL Server(2005+)和Oracle(11g +)，回答了该问题

The question is answered for SQL-Server (2005+) and Oracle (11g +)

很明显，sql-server实现相当有限，Oracle实现产生奇怪的列名.

Obviously the sql-server implementation is rather limited and Oracle implementation yields strange column names.

这些独立的解决方案还是基于某些ANSI标准的解决方案?

Are these independent solutions or are there based on some ANSI-standards?

推荐答案

它不在 ANSI-92 .

除草稿 SQL: 2003 .也没提到

注意:没有提及数据透视表和交叉表

Note: neither pivot nor cross-tab are mentioned

这篇关于PIVOT语句是否有ANSI规范?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！