Specify ISO compliant behavior of the Equals (=) and Not Equal To (<>) comparison operators when they are used with null values.
All comparisons against a null value evaluate to UNKNOWN.
Skyline behaviour.
- Rows containing NULL values (in relevant Skyline attributes) are always in the Skyline.
Sorting Behaviour
- NULL values result as TOP result during sorting
Specify ISO compliant behavior of the Equals (=) and Not Equal To (<>) comparison operators when they are used with null values.
All comparisons against a null value evaluate to UNKNOWN.
Skyline behaviour.
Sorting Behaviour