> > >

Microsoft SQL Server MCQs

Which of the following SQL queries correctly selects the rows from the table "employees" that have NULL value in the "salary" column?

SELECT * FROM employees WHERE salary=null

SELECT * FROM employees WHERE salary equals null

SELECT * FROM employees WHERE salary is null

SELECT * FROM employees WHERE salary contains null

Answer

Correct Answer: SELECT * FROM employees WHERE salary 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