开发者

Is there an ANSI Specification for the PIVOT statement?

开发者 https://www.devze.com 2023-02-07 06:43 出处:网络
Lately I asked the question How can I use PIVOT to show simultaneous average and count in its cells?

Lately I asked the question How can I use PIVOT to show simultaneous average and count in its cells?

The question is answered for SQ开发者_开发知识库L-Server (2005+) and Oracle (11g +)

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

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


It isn't in ANSI-92.

The later versions are not freely available (as far as I can tell) except a draft SQL:2003. Also not mentioned

Note: neither pivot nor cross-tab are mentioned

0

精彩评论

暂无评论...
验证码 换一张
取 消