Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
V0200:
The specification states the following:
-
Subclause 6.39, "<multiset value expression>": <multiset value expression> ::= <multiset term> | <multiset value expression> MULTISET UNION [ ALL | DISTINCT ] <multiset term> | <multiset value expression> MULTISET EXCEPT [ ALL | DISTINCT ] <multiset term> <multiset term> ::= <multiset primary> | <multiset term> MULTISET INTERSECT [ ALL | DISTINCT ] <multiset primary> ... Conformance Rules Without Feature S275, "Advanced multiset support", conforming SQL language shall not contain MULTISET UNION, MULTISET INTERSECTION, or MULTISET EXCEPT. NOTE — If MULTISET UNION DISTINCT, MULTISET INTERSECTION, or MULTISET EXCEPT is specified, then the Conformance Rules of Subclause 9.13, "Multiset element grouping operations", also apply. Subclause 9.13, "Multiset element grouping operations": Conformance Rules Without Feature S024, "Enhanced structured types", in conforming SQL language, the declared element type of a multiset operand of a multiset element grouping operation shall not be ST-ordered. Subclause 8.17, "<submultiset predicate>": <submultiset predicate> ::= <row value predicand> <submultiset predicate part 2> <submultiset predicate part 2> ::= [ NOT ] SUBMULTISET [ OF ] <multiset value expression> ... Conformance Rules Without Feature S275, "Advanced multiset support", conforming SQL language shall not contain a <submultiset predicate>. NOTE — The Conformance Rules of Subclause 9.13, "Multiset element grouping operations", also apply. Subclause 9.11, "Equality operations": Conformance Rules Without Feature S275, "Advanced multiset support", in conforming SQL language, the declared type of an operand of an equality operation shall not be multiset-ordered. NOTE — If the declared type of an operand OP of an equality operation is a multiset type, then OP is a multiset operand of a multiset element grouping operation. The Conformance Rules of Subclause 9.13, "Multiset element grouping operations", apply. Subclause 10.9, "<aggregate function>": <computational operation> ::= AVG | MAX | MIN | SUM | EVERY | ANY | SOME | COUNT | STDDEV_POP | STDDEV_SAMP | VAR_SAMP | VAR_POP | COLLECT | FUSION | INTERSECTION ... Conformance Rules Without Feature S275, "Advanced multiset support", conforming SQL language shall not contain a <computational operation> that immediately contains FUSION or INTERSECTION. NOTE — If INTERSECTION is specified, then the Conformance Rules of Subclause 9.13, "Multiset element grouping operations", also apply.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.