> > >

Microsoft SQL Server MCQs

Which one of the following correctly selects rows from the table myTable that have null in column column1?

SELECT * FROM myTable WHERE column1 is null

SELECT * FROM myTable WHERE column1 = null

SELECT * FROM myTable WHERE column1 EQUALS null

SELECT * FROM myTable WHERE column1 NOT null

SELECT * FROM myTable WHERE column1 CONTAINS null

Answer

Correct Answer: SELECT * FROM myTable WHERE column1 is null

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Microsoft SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it