Ordering, comparison, or grouping are not allowed on a JSON type, so no default ordering is provided. If a JSON column is used in a SET table, it is not included in the determination of the uniqueness of a row. Therefore, if all other columns in a row are equivalent to another row, the two rows are deemed equivalent.
You cannot use a JSON type in these clauses: GROUP BY, ORDER BY, PARTITION BY, WHERE, ON, SET, DISTINCT, HAVING, QUALIFY, IN, CUBE, GROUPING SETS or ROLLUP.
You can use JSON methods to isolate individual portions of a JSON instance for comparison. You can also cast the JSON type to a predefined type that can have relational comparisons performed on it.