Assuming UserProfile is a table containing a column Profession which accepts NULL value. What is the result of the below query. SET ANSI_NULLS ON SELECT Profession FROM UserProfile WHERE (Profession <> NULL)

183.

Assuming UserProfile is a table containing a column Profession which accepts NULL value.
What is the result of the below query.
SET ANSI_NULLS ON SELECT Profession FROM UserProfile WHERE (Profession <> NULL)

Returns records which has values in profession column

Gives an error.

Does not retrieve any records even if profession column contains values.

None of the above.

View Description

No description found.